@Venkat Chinnari The issue seems to be with cast from text to parquet. Try creating a sample table say table3 without serde properties but just 'stored as parquet' and check if insert overwrite works. Thanks and Regards, Sindhu ... View more

@Shihab The temp tables are created during the application run as intermediate data. These intermediate tables will not be removed in case the application fails and cleanup does not happen. Please check if applications are running which is generating data. Meanwhile, you can also try compressing the intermediate data by setting the property "hive.exec.compress.intermediate" as true in hive-site.xml. The related compression codec and other options are determined from Hadoop configuration variables mapred.output.compress*. Hope this helps. Thanks and Regards, Sindhu ... View more

@Varun Kumar Chepuri To initialize Metastore is to initialize the metastore database. Refer to the below link for manual configuration: https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_installing_manually_book/content/set_up_hive_hcat_configuration_files.html Hope this helps. Thanks and Regards, Sindhu ... View more

@Pierre Villard Sqoop internally using yarn jobs for extracting data from HDFS. ORC is regarding as better performance for read even with Hive: You can refer to below link for details: http://www.slideshare.net/StampedeCon/choosing-an-hdfs-data-storage-format-avro-vs-parquet-and-more-stampedecon-2015 Hope this helps. Thanks and Regards, Sindhu ... View more