Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Impala : argument of type 'NoneType' is not iterable

avatar
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;
Who agreed with this topic