使用bigData用户创建表
[bigData@bigData sbin]
hive> create table bigdata_table(name string, id string)
> row format delimited
> fields terminated by ‘,’
> lines terminated by ‘\n’;
OK
Time taken: 1.281 seconds
hive> load data inpath ‘/test_data/in.txt’ into table in_table;
FAILED: SemanticException [Error 10001]: Line 1:48 Table not found 'in_table’
hive> load data inpath ‘/test_data/in.txt’ into table bigdata_table;
Loading data to table hive_test.bigdata_table
OK
Time taken: 2.234 seconds
hive> select * from bigdata_table;
OK
杜甫 201922000401
李白 201922000402
Time taken: 0.37 seconds, Fetched: 2 row(s)
hive>

切换到hive用户查询表
[hive@bigData bigData]$ hive
hive> select * from bigdata_table;
OK
杜甫 201922000401
李白 201922000402

略过了授权操作居然也可以,老师我的问题出在哪儿呀？