Turns out that dividing by 1000 solves the issue:     CAST(tp.time_stamp/1000 AS timestamp) which outputs the correct date and time. I still find it odd that datetime from mysql gets stored as TIMESTAMP_MILLIS --> int64 in parquet and bigint for the field in impala which can't be converted back to datetime without an extra step, but, things work now...   ... View more

Hurray guys 🙂   Now i've configured hive 1.0.1. There is no longer error when i execute queries with "STORED AS TEXTFILE" in hive editor. And also successfully loaded hive sample tables. But when hue is not running i can  access hive in terminal. But when hue is running i can not access hive in terminal. It shows following exceptions  ERROR XSDB6: Another instance of Derby may have already booted the database /home/dhruv/metastore_db. java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:derby:;databaseName=metastore_db;create=true, username = APP. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------ java.sql.SQLException: Failed to start database 'metastore_db' with class loader sun.misc.Launcher$AppClassLoader@1137792, see the next exception for details.     Is it ok with hue as it is accessing same instance? Do i need to change any configuration so that both can work simultaneously ?     ... View more