07-18-2017 02:12 AM
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.
select p.product_id, p.product_name
from products p
order by p.product_id desc
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.
07-18-2017 02:56 AM
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 :)