[
https://issues.apache.org/jira/browse/DRILL-4155?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Abhishek Girish updated DRILL-4155:
-----------------------------------
Attachment: (was: profile.json.txt)
> Query with two-way join and flatten fails with "IllegalArgumentException:
> maxCapacity"
> --------------------------------------------------------------------------------------
>
> Key: DRILL-4155
> URL: https://issues.apache.org/jira/browse/DRILL-4155
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow, Storage - JSON
> Reporter: Abhishek Girish
> Attachments: drillbit.log.txt
>
>
> The following query on the Yelp Academic dataset fails to execute:
> {code}
> select u.name, b.name , flatten(b.categories) from
> maprfs.yelp_tutorial.`yelp_academic_dataset_user.json` u,
> maprfs.yelp_tutorial.`yelp_academic_dataset_business.json` b where
> u.average_stars = b.stars limit 10
> Query Failed: An Error Occurred
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> IllegalArgumentException: maxCapacity: -104845 (expected: >= 0) Fragment 1:0
> [Error Id: b0d99a6c-3434-49ce-8aa6-181993cdd853 on atsqa6c62.qa.lab:31010]
> {code}
> Tried on multiple setups in distributed mode - consistently fails.
> Dataset can be accessed from :
> https://s3.amazonaws.com/apache-drill/files/yelp.tgz (uncompressed tar
> archive)
> Log attached.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
