topic Re: Invalid alias error hive count(*) in Alteryx Designer Desktop Discussions

Invalid alias error hive count(*)

seanmcconnell — Mon, 15 Mar 2021 21:02:15 GMT

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.

Re: Invalid alias error hive count(*)

Qiu — Mon, 15 Mar 2021 23:12:47 GMT

@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.

Re: Invalid alias error hive count(*)

seanmcconnell — Tue, 16 Mar 2021 07:37:18 GMT

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.

Re: Invalid alias error hive count(*)

seanmcconnell — Tue, 16 Mar 2021 12:12:32 GMT

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.