[
https://issues.apache.org/jira/browse/DRILL-2805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-2805:
----------------------------------
Fix Version/s: (was: 1.0.0)
1.2.0
> Throw clear error message when maxdir/mindir UDFs are used in any other part
> of SQL, but where clause
> -----------------------------------------------------------------------------------------------------
>
> Key: DRILL-2805
> URL: https://issues.apache.org/jira/browse/DRILL-2805
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 0.9.0
> Reporter: Victoria Markman
> Assignee: Jason Altekruse
> Fix For: 1.2.0
>
>
> This error message is not right. I think the problem here is that we are not
> allowing to use these UDFs in projection list, group by or order by.
> Can we please have an error message that says that ?
> {code}
> 0: jdbc:drill:schema=dfs> select maxdir('dfs.test', 'bigtable') from
> smalltable group by maxdir('dfs.test', 'bigtable');
> Query failed: SYSTEM ERROR: 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.
> [6c9dd988-0960-4a3a-9495-535e245f0daa on atsqa4-134.qa.lab:31010]
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> {code}
> This is the correct way this error message is used:
> {code}
> 0: jdbc:drill:schema=dfs> select * from smalltable where dir0 =
> maxdir('dfs.test', 'bigtable') and dir1 = mindir('dfs.test', 'bigtable/2016');
> +------------+------------+------------+
> | columns | dir0 | dir1 |
> +------------+------------+------------+
> +------------+------------+------------+
> No rows selected (0.943 seconds)
> 0: jdbc:drill:schema=dfs> alter session set `planner.enable_constant_folding`
> = false;
> +------------+------------+
> | ok | summary |
> +------------+------------+
> | true | planner.enable_constant_folding updated. |
> +------------+------------+
> 1 row selected (0.108 seconds)
> 0: jdbc:drill:schema=dfs> select * from smalltable where dir0 =
> maxdir('dfs.test', 'bigtable') and dir1 = mindir('dfs.test', 'bigtable/2016');
> Query failed: SYSTEM ERROR: 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.
> [c22bad01-f9c7-43ba-b76c-8a11be518b40 on atsqa4-134.qa.lab:31010]
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> {code}
> Btw, I'm not sure I understand why we want to make constant folding
> configurable. Is the any benefit to not have it turned on ?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
