[
https://issues.apache.org/jira/browse/DRILL-6116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16352917#comment-16352917
]
John Humphreys commented on DRILL-6116:
---------------------------------------
Sorry for the delay. I moved on to another way of doing things and had to
recreate the failure. It's actually pretty trivial to recreate though.
By the way, I use drill on top of MapR and they tested and confirmed there was
an issue too - so it has some form of validation already.
I attached the requested JSON profiles; one for the failure and one for the
success gained from wrapping it in a sub-query.
* https://issues.apache.org/jira/secure/attachment/12909275/maxdir_fail.json
*
^https://issues.apache.org/jira/secure/attachment/12909276/maxdir_success.json^
> MAXDIR - Unsupported operation exception // partition explorer interface?
> -------------------------------------------------------------------------
>
> Key: DRILL-6116
> URL: https://issues.apache.org/jira/browse/DRILL-6116
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - JDBC
> Affects Versions: 1.10.0
> Reporter: John Humphreys
> Priority: Major
> Attachments: maxdir_fail.json, maxdir_success.json
>
>
> Using MAXDIR in drill seems to cause errors when trying to apply other
> standard where clause filters. Am I doing something wrong here?
> **This Query Fails**
> SELECT epoch_hour, entity, `1_average`, `1_95p`
> FROM dfs.`/path/drill-hour-final/`
> where
> dir0 = '2018' and dir1 = '01' and dir2 = '27'
> and dir3 = MAXDIR('dfs', concat('/path/drill-hour-final/',
> dir0, '/', dir1, '/', dir2, '/'))
> and entity = 1784928
> **With This Error**
> > SYSTEM ERROR: UnsupportedOperationException: The partition explorer
> > interface can only be used in functions that can be evaluated at
> > planning time. Make sure that the planner.enable_constant_folding
> > configuration option is set to true.
> >
> > Fragment 1:7
> >
> > [Error Id: d62c8227-db0e-4d31-9443-e570193d1010 on
> > psclxcpdevsys13.nomura.com:31010]
> **Wrapping it Makes it Work Without Error**
> select * from (
> SELECT epoch_hour, entity, `1_average`, `1_95p`
> FROM dfs.`/path/drill-hour-final/`
> where
> dir0 = '2018' and dir1 = '01' and dir2 = '27'
> and dir3 = MAXDIR('dfs', concat('/path/drill-hour-final/',
> dir0, '/', dir1, '/', dir2, '/'))
> ) where entity = 1784928
> epoch_hour entity 1_average 1_95p
> 1517086800 1784928 5.334722222222222 8.82857142857143
> 1517014800 1784928 25.944984717977217 40.37453087409783
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
