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

This article mainly introduces "how Hive executes the sql statement in the file". In the daily operation, I believe that many people have doubts about how Hive executes the sql statement in the file. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the doubt of "how Hive executes the sql statement in the file". Next, please follow the editor to study!

How Hive executes sql statements in files

Hive can run statements saved in the file, as long as the-f argument is used.

The create_table.sh script is as follows:

#! / bin/bashhive-f / opt/schedule/schedule-deploy/gfkafka_to_hive/gfrobot/hive/create_table.sql

The create_table.sql script is as follows: use odata_rob;create table if not exists gfrobot_login (uri string comment 'requested service address',) partitioned by (date string) stored as orc

Insert into table gfrobot_login partition (date) select * from login_temp; at this point, the study on "how Hive executes the sql statements in the file" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.