Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala ODBC driver settings for linux

Highlighted

Re: Impala ODBC driver settings for linux

Expert Contributor

Hi @GopinathS,
You are welcome.

Try to use a website like this one Upload files for free nd share the links..

Re: Impala ODBC driver settings for linux

New Contributor

@AcharkiMed

 

Hi,

 

We can't upload any of the artifcats,log files to open internet. Sorry about that.

Thanks a lot for your assistance.

Re: Impala ODBC driver settings for linux

Expert Contributor

Hi @GopinathS

You are welcome man, It's okay.
You can work on them before the upload by removing the authentification code lines and replacing your domains/IPs.. else try to read it and if you find a abnormal, WARN or ERROR message try to share it here.

Good luck.

Re: Impala ODBC driver settings for linux

New Contributor

Hi @AcharkiMed,

 

I went through the log files. Nothing alarming. No errors, no warnings. It beats me.

Out of columns a,b,c,d,e,f,g,h,i,j,k,l only e displays null value. If I select only g,h,i,j,k,l in the select, l gets null value. Only the 5 th column, always.

 

Thanks for your help.

 

 

Re: Impala ODBC driver settings for linux

Expert Contributor

Hmm, strange!
Let me propose a temporary solution, in your select query try always to fill the 5 th by a null value or write the 5th column name twice and just adapt your get method..

SELECT a,b,c,d,null,e,f,g,h,i,j,k,l FROM typetest;
or
SELECT a,b,c,d,e,e,f,g,h,i,j,k,l FROM typetest;


Lets me know if it doesn't work.

Re: Impala ODBC driver settings for linux

New Contributor

Thats a great idea. Will try that. How ever, we have 1000s of user reports. Unfortunately, we can't modify all.

Re: Impala ODBC driver settings for linux

New Contributor

@AcharkiMed

 

Hi,

 

I tried select a,b,c,d,null,e from table - worked

          select a,b,c,d,1,e from table - worked

          select a,b,c,d,'z',f from table - null value instead of 'z'

where a,b,c,d, e and f are table columns.

 

Thanks.

Re: Impala ODBC driver settings for linux

Expert Contributor

Sorry for the delay.
Hmm, now I have doubt in your backend application!
can you share the code used for read and browse your select query results..