HIVE讲义HIVE数据库是基于maperesources
1#建表(默认是内部表)createtabletest_hive(idbigint,accountstring,expensedouble,timestring)rowformatdelimitedfieldsterminatedby'\t';#建分区表(有大量数据增加的需要建分区表)createtabletest_part(idbigint,accountstring,expensedouble,timestring)partitionedby(logdatestring)rowformatdelimitedfieldsterminatedby'\t