John Humphreys created DRILL-6116: ------------------------------------- Summary: 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
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)