Forum Discussion

n228264's avatar
n228264
Regular Visitor
3 years ago
Solved

columns power query with bbdd name

I have a problem importing tables from a database because, name of the table and name of the variable are add in the column like this 

 

 

Any idea what can I do in order to see only de variables and not the name of the table. Other mates don't have this problem 

 

 

  • At the end I found the solution changing the configuration of serverside  hive.resultset.use.unique.column.names=false

     

    I did it in Cloudera ODBC driver for Apache Hive DSN 

     

3 Replies

  • n228264's avatar
    n228264
    Regular Visitor

    At the end I found the solution changing the configuration of serverside  hive.resultset.use.unique.column.names=false

     

    I did it in Cloudera ODBC driver for Apache Hive DSN 

     

  • n228264 , Usually we get column names only. What is the source? it may be because of the source

  • n228264's avatar
    n228264
    Regular Visitor

    The BBDD is private and I use an ODBC driver conector with Cloudera hive connection. Do you know if there is a configuration that makes this result?