#11 An error occurred when the query contains an indexed column.

open
nobody
5
2009-06-15
2009-06-15
YoungWoo Kim
No

Hi,

You can reproduce this problem like below using TEST_TABLE1.

Qeury:
select c1, count(*) as val1 from test_table1 where c1 is not null and c4 ='1' group by c1;

The query returns following messages:
Error: [java.util.EmptyStackException, java.util.EmptyStackException,
at java.util.Stack.peek(Stack.java:85),
at java.util.Stack.pop(Stack.java:67),
at com.business.cloudbase.hadoop.job.indexer.IndexInputFormat.getSplits(IndexInputFormat.java:214),
at org.apache.hadoop.mapred.JobClient.writeOldSplits(JobClient.java:810),
at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:781),
at org.apache.hadoop.mapred.JobClient.submitJob(JobClient.java:730),
at org.apache.hadoop.mapred.JobClient.runJob(JobClient.java:1252),
at com.business.cloudbase.hadoop.job.AggFunHandler.handleAggFun(AggFunHandler.java:725),
at com.business.cloudbase.hadoop.job.JobDriver.handleSelect(JobDriver.java:414),
at com.business.cloudbase.hadoop.job.JobDriver.executeQuery(JobDriver.java:356),
at com.business.cloudbase.hadoop.job.JobDriver.runJob(JobDriver.java:135),
at com.business.cloudbase.statement.query.QueryStmt.execute(QueryStmt.java:250),
at com.business.cloudbase.net.ClientHandler$CommandExecutor.handleSQL(ClientHandler.java:487),
at com.business.cloudbase.net.ClientHandler$CommandExecutor.run(ClientHandler.java:163)]

Cloudbase 1.3 and Hadoop 0.20.0

Thanks,
Youngwoo

Discussion