[ https://issues.apache.org/jira/browse/DRILL-6116?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16379152#comment-16379152 ]
John Humphreys commented on DRILL-6116: --------------------------------------- [~kkhatua] - Running into this again. Did you ever manage to take a peek? > 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)