Hive connection. Basic SQL queries sometimes don’t run properly on Toad Data Point. Can run the same query on Hive directly using other app.
Gets the error below when running a basic query. Also, some basic queries run fine, some doesn't.
ERROR:
"Hive error: Error while compiling statement: FAILED: SemanticException [Error 10002]: Line 219:40 Invalid column reference 'inventiv_account_name__c'
Hive queries should use table aliases and fully qualify all columns. The current statement may be missing one or more elements.
IE; SELECT a.col1 FROM table a."