hive -e "sql語(yǔ)句"

hive -f "sql文件"

導(dǎo)入數(shù)據(jù)到hive
hive> load data inpath 'xxxxxxxxxxxxxxxxx' overwrite | into table tableName [partation (dt = xxxxx)]

導(dǎo)出數(shù)據(jù)
hive> export table TableNmae to 'xxxxxxxxxxxxxx';
hive> import table TableNmae from 'XXXXXXXXXXXXXXXXXXX';

insert overwrite directroy 'XXXXXXXXXXXXXX' select * from tableName;