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

This article introduces the relevant knowledge of "Hive how to guide data to the local area". In the operation process of actual cases, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can read carefully and learn something!

Option 1: Use linux pipe symbol replacement

hive -e "set hive.cli.print.header=true;select * from table_name limit 100" |sed 's/\t/,/g' > result.csv Scheme 2: Use hive insert to import data to local, specify delimiter insert overwrite local directory '/home/hadoop/20180303'row format delimited fields terminated by ','select * from table_name limit 100"Hive how to import data to local" content is introduced here, thank you for reading. If you want to know more about industry-related knowledge, you can pay attention to the website. Xiaobian will output more high-quality practical articles for everyone!

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.