Invalid alias error hive count(*)

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.

Input

In Database

In-Database

Accepted answers

seanmcconnell

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.

All comments

Qiu

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

seanmcconnell

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.

yymm.png

count.png

cloudera_2.05.png

input_data_settings.png

seanmcconnell

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703