小刀的专栏

转自：http://www.cnblogs.com/ggjucheng/archive/2013/01/04/2844393.html这里罗列常用操作，更多参考 https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Create%2FDrop%2FTruncateTab

转自：http://www.cnblogs.com/ggjucheng/archive/2013/01/04/2844673.htmlhive有两种数据修改方式从文件加载到hive表加载数据到表时，hive不会做任何转换。加载操作是纯粹的复制/移动操作，移动数据文件到相应的hive表。语法LOAD DATA [LOCAL] INPATH 'fil

导入本地：insert overwrite local directory '/mnt/spark-tmp/apps.txt' row format delimited fields terminated by ',' select * from aaa  limit 10000;导入HDFS：insert overwrite directory '/mnt/spa

./sqoop export --connect jdbc:mysql://localhost:3306/test --username root --password 123456 --table pptr --export-dir /user/hive/warehouse/moji.db/ttpr/part_date=2015-06-16/part_type=1 --input-fields-

命令：CREATE TABLE tablename_temp  # 创建表row format delimited fields terminated by ','  #指定分隔符号AS select filed1,filed2 from tablename order by filed1 desc limit 20; #查询方式获取数据源