Forum Discussion

sruthicb's avatar
sruthicb
Frequent Visitor
3 years ago
Solved

Data load using ODBC Connection-Hive DB

I'm using ODBC connection to connect to Hive database and using below simple query to query the database.   select col1,col2,col3 from table;    when the data is loaded in the preview in the he...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi sruthicb 

     

    I don't have a Hive database to do a test, but maybe you can give a new name for every column in the SQL statement with "AS". For example, 

    select 
col1 as 'col1',
col2 as 'col2',
col3 as 'col3' 
from table;

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi sruthicb 

 

I don't have a Hive database to do a test, but maybe you can give a new name for every column in the SQL statement with "AS". For example, 

select 
col1 as 'col1',
col2 as 'col2',
col3 as 'col3' 
from table;

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.