Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala : argument of type 'NoneType' is not iterable

Highlighted

Impala : argument of type 'NoneType' is not iterable

New Contributor

I have imported some data (30 million rows) to the quickstart VM (single node) using the following command. 

sqoop import  -Dmapreduce.map.memory.mb=1024 -Dmapreduce.map.java.opts=-Xmx7200m -Dmapreduce.task.io.sort.mb=2400 --connect jdbc:mysql://my.ip.address/perkdbdev --username root -P --hive-import --table table_name --as-parquetfile --warehouse-dir=/home/cloudera/hadoop  -m 10

It has added the data successfully, but I am facing with an issue when I issue any aggregate function statement from the Hue Query editor interface for Impala. I am getting 

argument of type 'NoneType' is not iterable

Do I need to do anything after importing the data to avoid this error ? I googled for sometime, but the only information I got is that this is some error with Python, but I am not very sure about it. I am getting the error while running the following query .

 

select count(id) from my_table_name;
Don't have an account?
Coming from Hortonworks? Activate your account here