Support Questions

Find answers, ask questions, and share your expertise

When i upload a table from de HDFS to hive get this error:

avatar
Explorer
 Successfully created table 'cliente_reclamo'
 Successfully created table 'lnqrgszflzhjgtomunuzlrtqunzfzv'
 Current selected table 'undefined' has been deleted from Hive Server. Transitioning out.
1 ACCEPTED SOLUTION

avatar
Master Mentor

@yadir Aguilar
What you posted does not look like an error. Can you please provide more details like the UI screenshot where you see this message?
Or if you are using Hive View then can you please share the complete hive view log/ambari-server.log

/var/log/ambari-server/hive-next-view/hive-view.log
/var/log/ambari-server/hive20-view/hive20-view.log
/var/log/ambari-server/ambari-server.log

.


View solution in original post

2 REPLIES 2

avatar
Master Mentor

@yadir Aguilar
What you posted does not look like an error. Can you please provide more details like the UI screenshot where you see this message?
Or if you are using Hive View then can you please share the complete hive view log/ambari-server.log

/var/log/ambari-server/hive-next-view/hive-view.log
/var/log/ambari-server/hive20-view/hive20-view.log
/var/log/ambari-server/ambari-server.log

.


avatar
Explorer

88382-hive-error-log.png

hi @Jay Kumar SenSharma

I checked the hive20 log and see this error:

I also found this:

THE FILA FORMAT DELIMITED THE FIELDS ENDED BY '' ESCAPED BY '' STORED AS TEXTFILE, Account ID: 1, TdI: 140

I think the row format is invalid, the file that you try to upload to a background account for large data.