这是我创建的表的代码
hive> create external table dblab.bigdata_user(id INT,uid STRING,item_id STRING,behaiver_type INT,item_catagory STRING,visit_data DATE,province STRING) COMMENT 'Welcome to xmu dblab!' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE LOCATION '/bigdatacase/dataset';
修复分区数据 msck repair table tablename;
刷新表 refresh tablename;