You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Paul Rogers (JIRA)" <ji...@apache.org> on 2017/02/09 00:50:41 UTC
[jira] [Updated] (DRILL-5246) NULL not supported in VALUES clause
[ https://issues.apache.org/jira/browse/DRILL-5246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Paul Rogers updated DRILL-5246:
-------------------------------
Description:
The following is valid in DRILL:
{code}
SELECT * FROM (VALUES ( TRUE, FALSE ))
SELECT * FROM (VALUES ( TRUE ), (FALSE))
{code}
But, the following is not:
{code}
SELECT * FROM (VALUES ( TRUE, NULL, FALSE ))
SELECT * FROM (VALUES ( TRUE ), (FALSE), (NULL))
{code}
Internally, a bare "null" may be an issue since Drill does not have a null type. So, the first example might be a problem (a column for which the only value is Null, but we don't know a null of which type.) But, the second example should be fine: we know that the type is boolean.
While Drill's error reporting in the web UI is not clear, it seems that I'm getting a syntax error when using Null:
{code}
org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR:
From line 1, column 43 to line 1, column 46: Illegal use of 'NULL' SQL Query null
{code}
was:
The following is valid in DRILL:
{code}
SELECT * FROM (VALUES ( TRUE, FALSE ))
SELECT * FROM (VALUES ( TRUE ), (FALSE))
{code}
But, the following is not:
{code}
SELECT * FROM (VALUES ( TRUE, NULL, FALSE ))
SELECT * FROM (VALUES ( TRUE ), (FALSE), (NULL))
{code}
Internally, a bare "null" may be an issue since Drill does not have a null type. So, the first example might be a problem (a column for which the only value is Null, but we don't know a null of which type.) But, the second example should be fine: we know that the type is boolean.
While Drill's error reporting in the web UI is not clear, it seems that I'm getting a syntax error when using Null.
> NULL not supported in VALUES clause
> -----------------------------------
>
> Key: DRILL-5246
> URL: https://issues.apache.org/jira/browse/DRILL-5246
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.9.0
> Reporter: Paul Rogers
>
> The following is valid in DRILL:
> {code}
> SELECT * FROM (VALUES ( TRUE, FALSE ))
> SELECT * FROM (VALUES ( TRUE ), (FALSE))
> {code}
> But, the following is not:
> {code}
> SELECT * FROM (VALUES ( TRUE, NULL, FALSE ))
> SELECT * FROM (VALUES ( TRUE ), (FALSE), (NULL))
> {code}
> Internally, a bare "null" may be an issue since Drill does not have a null type. So, the first example might be a problem (a column for which the only value is Null, but we don't know a null of which type.) But, the second example should be fine: we know that the type is boolean.
> While Drill's error reporting in the web UI is not clear, it seems that I'm getting a syntax error when using Null:
> {code}
> org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR:
> From line 1, column 43 to line 1, column 46: Illegal use of 'NULL' SQL Query null
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)