Tuesday 15 May 2012

hadoop - Hive table is not showing up in command line interface -



hadoop - Hive table is not showing up in command line interface -

i had script create hive table, script completing unable see table, please help.

below script create table #!/bin/bash hive <<! > hive_out.log create table goodrecords( id int, name string, state string, phone_no int, gender string) row format delimited fields terminated ',' stored textfile; exit; !

logs generated: `hive> create table goodrecords(

id int, name string, state string, phone_no int, gender string) row format delimited fields terminated ',' stored textfile; hive> exit;`

gui hadoop shows table had been created: /user/hive/warehouse/goodrecords

command line output showtables. hive> show tables; ok time taken: 0.34 seconds

there issue setting hive metastore service.

just seek restart metastore service. should work.

hadoop hive bigdata

No comments:

Post a Comment