Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Dhanunjaya
Contributor
Contributor

Failed to describe table using ODBC

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)

Labels (1)
1 Solution

Accepted Solutions
john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

4 Replies
Hordy_Beauzile
Support
Support

Hi @Dhanunjaya ,

What source endpoint are you replicating from, which version? What  ODBC drivers are you using?

Best,

Hordy

Michael_Litz
Support
Support

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

Dhanunjaya
Contributor
Contributor
Author

Hi Hordy,

The source connection is for SQL Server and ODBC Driver 11 for sql server.  version : 2014.120.5543.11

Regards,

Dhanunjaya

john_wang
Support
Support

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.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!