Shulou(Shulou.com)06/01 Report--

This article will explain in detail what SQL is commonly used in Hive. Xiaobian thinks it is quite practical, so share it with you as a reference. I hope you can gain something after reading this article.

Common SQL operations--create database if does not exist userdb;drop databases if exists userdb;--view table details show create table tablename;--Query a table, create a new table create table tablename as select * from tablenamehive table operation--create hive table create external table if not exists table_name ( `id` string comment 'id number',`name` string comment ' name',`height` double comment 'height',) comment ' student information table 'partition by (dt string)row format delimitedfields terminated by '\t'lines terminated by '\n'stored as textfilelocation 'hdfs file path';--delete hive table drop table if exists table_name; partition operation--delete partition alter table_name drop if exists partition (dt = '20200820');--New partition, store data alter table_name add if not exists partition (dt ='20200820 ') location 'hdfs file path';--rename partition alter table_name partition xxxxx rename to partition xxxxx; About "Hive commonly used SQL what" this article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it to let more people see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.