Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Impala ODBC driver settings for linux

avatar
Explorer

Is there a parameter in Impala ODBC driver that would define the number of characters/bytes fetched in a row. When I create a report in OBIEE with varchar/char/string characters, we loose one of the columns. But same size of report with int/bigint works fine. I suspect it could be because of the array size that loads a row. Any help would be appreciated. Thanks. 

17 REPLIES 17

avatar
Master Collaborator

Hi @GopinathS,
You are welcome.

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

avatar
Explorer

@AcharkiMed

 

Hi,

 

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

Thanks a lot for your assistance.

avatar
Master Collaborator

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.

avatar
Explorer

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.

 

 

avatar
Master Collaborator

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.

avatar
Explorer

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

avatar
Explorer

@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.

avatar
Master Collaborator

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..