Reply
New Contributor
Posts: 2
Registered: ‎07-18-2017

All SQLs are failing in Hue Impala editor

Hi Team,

 

I am a newbie in Hadoop. I started today with the tutorial of cloudera. I have quickstart vm 5.4.2.

 

I imported MYSQL retail db tables into HDFS along with schema files. I created external tables in Impala query editor and then applied show tables; command. I can see those tables and also at the left hand side of the editor, I can see these tablenames.

 

Problem is whenever I am writing any SQL involving these tables, it is timed out. Then from recent query tab, I can see below error.

 

SQL:

select p.product_id, p.product_name
from products p
order by p.product_id desc
limit 10;

Error after few minutes as seen in the result column:

a2b_base64() argument 1 must be string or read-only character buffer, not None

 

Can anybody please help? I am not even able to drop these tables and recreate.

New Contributor
Posts: 2
Registered: ‎07-18-2017

Re: All SQLs are failing in Hue Impala editor

Hi,

 

I am really not sure what happened but when I restarted Hue and Impala editor, tried to read sample data from metastore, from that point my SQLs started providing correct result.

 

Looks like it is solved now :)

 

Thanks,

Dipanjan

Announcements

Our community is getting a little larger. And a lot better.


Learn More about the Cloudera and Hortonworks community merger planned for late July and early August.