CODEWITHSUNDEEP
apache-drillmapr
Srihari Karanth
Srihari Karanth

Reputation: 2167

Apache Drill: Hash join does not support schema changes Error on extra column

When querying a table in Apache Drill, i get this error:

SYSTEM ERROR: SchemaChangeException: Hash join does not support schema Changes.

The query is like below:

Select abc, xyz, proxyip from D_UNIV_TABLE where SUB_NUM in (select SUB_NUM from TABLE_B);

The same query works fine when proxyip column is removed from select clause.

Select abc, xyz from D_UNIV_TABLE where SUB_NUM in (select SUB_NUM from TABLE_B);

proxyip has null values and ip addresses. How can addition of a column give Schema change exception?

MapR Apache Drill Version: 1.10

Upvotes: 2

Views: 989

Answers (1)

Vitalii Diravka
Vitalii Diravka

Reputation: 855

Looks like a bug. Please create a Jira ticket and provide the plan, data and logs https://issues.apache.org/jira/projects/DRILL

The possible workaround is to use CAST(proxyip AS <data type>).

Upvotes: 1

Related Questions