{"id":131835,"date":"2020-07-05T08:23:15","date_gmt":"2020-07-05T00:23:15","guid":{"rendered":"http:\/\/4563.org\/?p=131835"},"modified":"2020-07-05T08:23:15","modified_gmt":"2020-07-05T00:23:15","slug":"hive-%e5%ad%a6%e4%b9%a0%e4%b9%8b%e8%b7%af%ef%bc%88%e5%9b%9b%ef%bc%89hql%e7%9a%84%e5%9f%ba%e6%9c%ac%e8%af%ad%e6%b3%95","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=131835","title":{"rendered":"hive \u5b66\u4e60\u4e4b\u8def\uff08\u56db\uff09HQL\u7684\u57fa\u672c\u8bed\u6cd5"},"content":{"rendered":"

<\/a>\u6570\u636e\u5e93\u76f8\u5173\u7684 DDL<\/h3>\n

1\u3001\u521b\u5efa\u5e93<\/p>\n

\n\n\n
\n
1<\/span>
2<\/span>
3<\/span>
4<\/span>
<\/pre>\n<\/td>\n
\n
CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] database_name<\/span>
\u3000\u3000[COMMENT database_comment]\u3000\u3000\u3000\u3000\u3000\u3000 //\u5173\u4e8e\u6570\u636e\u5757\u7684\u63cf\u8ff0<\/span>
\u3000\u3000[LOCATION hdfs_path]\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u3000//\u6307\u5b9a\u6570\u636e\u5e93\u5728HDFS\u4e0a\u7684\u5b58\u50a8\u4f4d\u7f6e<\/span>
\u3000\u3000[WITH DBPROPERTIES (property_name=property_value, ...)];\u3000\u3000\u3000\u3000//\u6307\u5b9a\u6570\u636e\u5757\u5c5e\u6027<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
1.1\u3001\u521b\u5efa\u666e\u901a\u7684\u6570\u636e\u5e93<\/p>\n
\n\n\n
\n
1<\/span>
<\/pre>\n<\/td>\n
\n
create database db1;<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
1.2\u3001\u521b\u5efa\u5e93\u7684\u65f6\u5019\u68c0\u67e5\u5b58\u4e0e\u5426<\/p>\n
\n\n\n
\n
1<\/span>
<\/pre>\n<\/td>\n
\n
create database IF NOT EXISTS db1;<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
1.3\u3001\u521b\u5efa\u5e93\u7684\u65f6\u5019\u5e26\u6ce8\u91ca<\/p>\n
\n\n\n
\n
1<\/span>
<\/pre>\n<\/td>\n
\n
create database IF NOT EXISTS db1 COMMENT '\u6d4b\u8bd5\u5e93\u4e00';<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
1.4\u3001\u521b\u5efa\u5e26\u5c5e\u6027\u7684\u5e93<\/p>\n
\n\n\n
\n
1<\/span>
<\/pre>\n<\/td>\n
\n
create database db1 with deproperties('creator'='hadoop','date'='2019-09-16')<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
2\u3001\u67e5\u770b\u5e93<\/p>\n
2.1\u3001\u67e5\u770b\u6240\u6709\u6570\u636e\u5e93<\/p>\n
\n\n\n
\n
1<\/span>
<\/pre>\n<\/td>\n
\n
show databases;<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
2.2\u3001\u663e\u793a\u6570\u636e\u5e93\u7684\u8be6\u7ec6\u5c5e\u6027\u4fe1\u606f<\/p>\n
\n\n\n
\n
1<\/span>
<\/pre>\n<\/td>\n
\n
desc database extended t3;<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
2.3\u3001\u67e5\u770b\u5f53\u524d\u6b63\u5728\u4f7f\u7528\u7684\u6570\u636e\u5e93<\/p>\n
\n\n\n
\n
1<\/span>
<\/pre>\n<\/td>\n
\n
select current_database();<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
2.4\u3001\u67e5\u770b\u521b\u5efa\u5e93\u7684\u8be6\u7ec6\u8bed\u53e5<\/p>\n
\n\n\n
\n
1<\/span>
<\/pre>\n<\/td>\n
\n
show create database db1;<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
3\u3001\u5220\u9664\u5e93
\u8bed\u6cd5\uff1a<\/p>\n
\n\n\n
\n
1<\/span>
2<\/span>
<\/pre>\n<\/td>\n
\n
drop database dbname;<\/span>
drop database if exists dbname;<\/span>
<\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/figure>\n
\u9ed8\u8ba4\u60c5\u51b5\u4e0b\uff0chive \u4e0d\u5141\u8bb8\u5220\u9664\u5305\u542b\u8868\u7684\u6570\u636e\u5e93\uff0c\u6709\u4e24\u79cd\u89e3\u51b3\u529e\u6cd5\uff1a<\/p>\n