Support Questions
Find answers, ask questions, and share your expertise

Need details on how to use QueryDatabaseTable against Hive

New Contributor

I am getting an error when I try to reach Hive from the QueryDataBaseTable processor: Failed to process session due to Unable to communicate with database in order to determine column types

The HiveConnection works perfectly in others Processor such PutHiveQL or PutHDFS.

The processor has just simple configurations:

Database Connection Pooling Service HiveConnectionPoolMaximo
Database Type Generic
Table Name ${DB}.${Table}
Columns to Return ${column1},${column2},${column3}
Additional WHERE clause No value set
Custom Query No value set
Maximum-value Columns ${DB}.${Table}

Any help will really apprecite it!