AnsweredAssumed Answered

Drill - Error with MAXDIR and Where Clause Filter?

Question asked by john.humphreys on Jan 29, 2018
Latest reply on Feb 5, 2018 by Hao Zhu

Using MAXDIR in drill seems to cause errors when trying to apply other standard where clause filters. Am I doing something wrong here? (Drill 1.10 with 1.12 JDBC driver)

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

Outcomes