@MR_KD As this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post. Thanks. ... View more

Hi,   Sorry to make you waiting. Yes, that solution resolved the issue. But i have 1 more issue. After the data successfully inserted to textfile table. Then i need to insert the data to parquet table from textfile table. But it failed insert to parquet table. Error message: "[FATAL] 10:25:08 vaproject.vmlog_0_4.VMLOG- tHiveRow_1 Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask". What is wrong or missing? Please need your help. Thank you.   Sincerely,   Gideon Maruli IT Data Management - Bank Mayapada ... View more

May i know if the table was created from the data that was exported in some other format like 'txt' format or something ? if this is true then, starting from CDP 7.x versions, the default file format is parquet. So, when the table is imported, it will be created in parquet format, but its original files will in 'txt' format. ... View more

Hello Michael,    In your insert query are you referring to table like "databasename.tablename"?, if yes, then first try to execute    "use databasename"    And then execute the query. ... View more