I am getting invalid table or column error possible column names...
Using a cloudera impala driver. Select * from table works.
But when I try
select col1, count(*) as cnt from table
It throws an error 'cnt' not a valid table or column reference. I changed the input tool to not use quotes but the above error is still showing. It's like alteryx is still using the quotes even though the input tool is configured to not use quotes.
Tried some hive settings on the user dsn itself to no avail.
Solved! Go to Solution.
@seanmcconnell
It happens to me sometime also, that it seems there is some kind of weired "cache" there.
I usually try the refresh button and if it still not working, just delete the input tool and replace a new one instead.
I'm using cloudera 2.05 to connect. The error is a 10004 impala one when I try a select col1 as yymm, count(*) from table
and can be a 10000 general error for select count(*) from table.
I tried refreshing the input tool as suggested but it did not work.
Got it working. Had the wrong driver, needed MapR Hive ODBC Connector.
Cloudera impala driver worked on a select * but for anything else the query was wrapped in a syntax that alteryx didn't like.