[jira] [Created] (DRILL-6116) MAXDIR - Unsupported operation exception // partition explorer interface?

["John Humphreys (JIRA)" <ji...@apache.org>]

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)