Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Teaam,
While reload the task we are getting below error,Please help us.
we have installed valied ODBC drivers.
ERROR :
Failed to describe table using ODBC. [1000100] (hadoop_metadata.c:436)
Failed to describe table 'exec_analytics_db'.'ma_card_meas_summ_bymonth_pivot_final' [1000100] (hadoop_load.c:421)
Handling new table 'exec_analytics_db'.'ma_card_meas_summ_bymonth_pivot_final' failed [1000100] (endpointshell.c:2733)
Hello @Dhanunjaya ,
From the error messages:
2022-05-18T09:25:05 [TARGET_LOAD ]E: Failed to describe table using ODBC.
2022-05-18T09:25:05 [TARGET_LOAD ]E: Failed to describe table 'exec_analytics_db'.'ma_contindays_covg_final'
Looks to me it's likely a privileges issue. The user you used in the Hadoop endpoint connection cannot access the Hive table, or database.
You may follow bellow steps to confirm that:
1. IN Hadoop target endpoint --> Hive Access --> Access Hive using, set it to "No Access"
If the problem disappeared and the records can be write to HDFS, then it's a pure ODBC issue.
2. Logon to Hive/beeline Client (by the same account as the endpoint) then execute SQL:
describe formatted ma_contindays_covg_final
Probably you will get the similar error. Fix the error then try it again by Replicate task.
Hope this helps.
Regards,
John.
Hi @Dhanunjaya ,
What source endpoint are you replicating from, which version? What ODBC drivers are you using?
Best,
Hordy
Hi Dhanunjaya,
This looks like it may be more involved than a chat session.
I am thinking that yo should open a case for this and when you do please include the task diagnostics package and the log file that has this error.
One of our support team will take the case and work with you on it.
Thanks
Michael
Hi Hordy,
The source connection is for SQL Server and ODBC Driver 11 for sql server. version : 2014.120.5543.11
Regards,
Dhanunjaya
Hello @Dhanunjaya ,
From the error messages:
2022-05-18T09:25:05 [TARGET_LOAD ]E: Failed to describe table using ODBC.
2022-05-18T09:25:05 [TARGET_LOAD ]E: Failed to describe table 'exec_analytics_db'.'ma_contindays_covg_final'
Looks to me it's likely a privileges issue. The user you used in the Hadoop endpoint connection cannot access the Hive table, or database.
You may follow bellow steps to confirm that:
1. IN Hadoop target endpoint --> Hive Access --> Access Hive using, set it to "No Access"
If the problem disappeared and the records can be write to HDFS, then it's a pure ODBC issue.
2. Logon to Hive/beeline Client (by the same account as the endpoint) then execute SQL:
describe formatted ma_contindays_covg_final
Probably you will get the similar error. Fix the error then try it again by Replicate task.
Hope this helps.
Regards,
John.