0

I have cloudera quickstart 5.5 on linux red hat. I try create metastore tables by hue, but these tables were created in hive1 instead of hive2 too. So when I do queries by hive line, queries and show tables works, but in beeline (hive2) is empty (show tables no dispaly anitihng). How I create tables by hue or other way to be able to consult queries by beeline? Thanks.

Miguel Angel Sanchez
  • 3
  • 3
  • what is the backend database for your Metastore? – user1314742 Apr 20 '16 at 17:06
  • Metastore tables are in default database – Miguel Angel Sanchez Apr 20 '16 at 21:48
  • My question was if you have configured another dabase to store Hive metadata. By default it is Derby local database, but you could use MySQL, Postrgres, Oracle o MS Server to hold those data. So are you using any f those? or you are using the default Derby local database? – user1314742 Apr 21 '16 at 07:44
  • would you put the hive-site.xml configuration if it is possible? Not the whole file, just the properties defining the dataabse connection and location – user1314742 Apr 21 '16 at 10:08
  • I believe that is because hive1 uses metastore folder other than this used by hive2. and here you could not see the tables created by hive1 in hive2 – user1314742 Apr 21 '16 at 10:08
  • I´m using default Derby local database, now shows databse and tables 0: jdbc:hive2://> show databases; 14/01/31 16:50:47 INFO log.PerfLogger: ... +----------------+ | database_name | +----------------+ | default | +----------------+ 1 row selected (0.026 seconds) but when i do this: 0: jdbc:hive2://> Select * from GOLD 0: jdbc:hive2://> 'Select * from gold' or 0: jdbc:hive2://>Select * from gold; 0: jdbc:hive2://>Select * from gold > /path/ I don´t see the result anywhere – Miguel Angel Sanchez Apr 21 '16 at 10:11

0 Answers0