Impala ODBC driver settings for linux

[#1]

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. 

[#2]

Hi @GopinathS,
You are welcome.

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

[#3]

@AcharkiMed

Hi,

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

Thanks a lot for your assistance.

[#4]

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.

[#5]

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.

[#6]

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.

[#7]

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

[#8]

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

[#9]

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