Re: hive session drops tables when restarted

2016-08-09 Thread Sumit Khanna
Hello Mich, Well there was a little problem, as of now it asks for adding mysql connector to classpath. I simply added the mysql connector jars to /opt/hive/lib/ I believe that should have sufficed isnt it? ie. mysql-metadata-storage-0.9.1.1.tar.gz mysql-connector-java-5.1.39.tar.gz it still gi

Re: hive session drops tables when restarted

2016-08-08 Thread Sumit Khanna
have you configured your hive.site.xml to refer to the new metadata on MySQL ? javax.jdo.option.ConnectionURL jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true metadata is stored in a MySQL server javax.jdo.option.ConnectionDriverName com.mysql.jdbc.

Re: hive session drops tables when restarted

2016-08-08 Thread Mich Talebzadeh
have you configured your hive.site.xml to refer to the new metadata on MySQL ? Mine is on oracle javax.jdo.option.ConnectionURL jdbc:oracle:thin:@rhes564:1521:mydb12 JDBC connect string for a JDBC metastore and username and password can you log in to MySQL database and look at

hive session drops tables when restarted

2016-08-08 Thread Sumit Khanna
Hello, I am facing a weird issue with hive. Initially we had hive configured against the default derby, and hardly select * / raw columns were working for my parquet tables. However, having configured it against mysql metastore db now, the all my queries involving min / max / order by / where et