[jira] [Created] (DRILL-2805) Throw clear error message when maxdir/mindir UDFs are used in any other part of SQL, but where clause

["Victoria Markman (JIRA)" <ji...@apache.org>]

Victoria Markman created DRILL-2805:
---------------------------------------

             Summary: 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
    Affects Versions: 0.9.0
            Reporter: Victoria Markman


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)