[
https://issues.apache.org/jira/browse/DRILL-1311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14151376#comment-14151376
]
Neeraja edited comment on DRILL-1311 at 9/29/14 5:35 AM:
---------------------------------------------------------
Another use case for this error.
0: jdbc:drill:zk=local> SELECT b.name, sum(r.votes.cool) FROM
dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_review.json`
r JOIN
dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_business.json`
b ON (r.business_id = b.business_id) GROUP BY b.name ORDER BY
sum(r.votes.cool) DESC LIMIT 10;
Query failed: Failure while running fragment. Hash join does not support schema
changes [4babdaac-0228-44f7-a280-028d46bb61b5]
was (Author: neeraja):
Another use case for this error.
0: jdbc:drill:zk=local> SELECT b.name, sum(r.votes.cool)
. . . . . . . . . . . > FROM
dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_review.json`
. . . . . . . . . . . > r JOIN
dfs.`/users/nrentachintala/Downloads/yelp_dataset_challenge_academic_dataset/yelp_academic_dataset_business.json`
b
. . . . . . . . . . . > ON (r.business_id = b.business_id)
. . . . . . . . . . . > GROUP BY b.name
. . . . . . . . . . . > ORDER BY sum(r.votes.cool) DESC
. . . . . . . . . . . > LIMIT 10;
Query failed: Failure while running fragment. Hash join does not support schema
changes [4babdaac-0228-44f7-a280-028d46bb61b5]
> Hash join does not support schema changes error
> -----------------------------------------------
>
> Key: DRILL-1311
> URL: https://issues.apache.org/jira/browse/DRILL-1311
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Neeraja
> Assignee: Ramana Inukonda Nagaraj
> Fix For: 0.6.0
>
>
> - Create a directory with a couple of JSON files. One with columns a,b and
> second with columns a,b,c.
> - a & b attributes have same data types across both the files
> - create a view by selecting columns a, b from the directory
> - Join the view with any other table
> An error shows up indicating that 'Hash join does not support schema changes'.
> There is a schema change across the files with a new element being added,
> however given that specific columns a,b are selected in the view, expect that
> query works fine.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
