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

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

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

@AcharkiMed   Hi,   We can't upload any of the artifcats,log files to open internet. Sorry about that. Thanks a lot for your assistance. ... View more

Hi @AcharkiMed ,   I have the log files.How do I send those to you? I don't see an option to upload files.   Thanks. ... View more

@AcharkiMed   Tried. Did not change the outcome. ... View more

@AcharkiMed   About the query, it is as simple as select * from typetest. This table only has 6 rows and may be 8 to 9 columns.   Thanks. ... View more

@AcharkiMed   Will post the log files soon. Here are the versions and config for your reference   CDH-5.9.1-1.cdh5.9.1.p2260.2452 impala-2.7.0 hive 1.1.0   ODBC.INI config ---------------------- [IMP_TEST] Driver=/opt/cloudera/impalaodbc/lib/64/libclouderaimpalaodbc64.so Description=Cloudera ODBC Driver for Impala Database= Host= UID= PWD= Port= AuthMech=3 SSL=1 CAIssuedCertNamesMismatch=1 TrustedCerts=/obi/apps/truststore.pem ErrorMessagesPath=/opt/cloudera/impalaodbc/ErrorMessages/ StringColumnLength = 32767 TSaslTransportBufSize=1000 RowsFetchedPerBlock=10000 SocketTimeout=0 UseNativeQuery=0     ... View more

@AcharkiMed. Thanks a lot for your suggestion. I tried this parameter with default value and even tried adding few 0s to this. But still, its an issue. I do not see all the column values. Each report has a particular column, at different positions, that does not get displayed. This does not change. If column emp_name is not appearing in report A, it's always this column. But, this column value appears in another report, Report B which may also have all string fields. In Report B, it would be some other column in random order that disappears. ... View more