drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-1877) Throw unsupported error message for || operator early in the parsing stage
Date Fri, 24 Apr 2015 21:09:38 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Victoria Markman resolved DRILL-1877.
-------------------------------------
    Resolution: Fixed

Concat operator was implemented and drill-2354 is a reference to documentation.

> Throw unsupported error message for || operator early in the parsing stage
> --------------------------------------------------------------------------
>
>                 Key: DRILL-1877
>                 URL: https://issues.apache.org/jira/browse/DRILL-1877
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: SQL Parser
>    Affects Versions: 0.7.0
>            Reporter: Victoria Markman
>            Assignee: Sean Hsuan-Yi Chu
>            Priority: Minor
>             Fix For: 0.9.0
>
>         Attachments: DRILL-1877.1.patch, DRILL-1877.2.patch, DRILL-1877.3.patch, DRILL-1877.4.patch,
DRILL-1877.5.patch, DRILL-1877.6.patch
>
>
> If we don't plan to support concat operator (||), we should throw a decent error message
early.
> The error is cryptic:
> 0: jdbc:drill:schema=dfs> select cast(l_orderkey as varchar(10)) || '-' || cast(l_partkey
as varchar(10)) from cp.`tpch/lineitem.parquet`;
> Query failed: Query stopped., Line 65, Column 29: "value" is neither a method, a field,
nor a member class of "org.apache.drill.exec.expr.holders.VarCharHolder" [ bc85685d-e08a-494b-aa9f-5b3fa4ee4033
on atsqa4-133.qa.lab:3
> 1010 ]
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> I believe that error that I'm getting from the query below is the result of not throwing
"Unsupported" message earlier.
> Please correct me if I'm wrong.
> 0: jdbc:drill:schema=dfs> select
> . . . . . . . . . . . . >         cast(l_orderkey as varchar(10)) || '-' || cast(l_partkey
as varchar(10))
> . . . . . . . . . . . . > from
> . . . . . . . . . . . . >         (
> . . . . . . . . . . . . >         select  sum(l_quantity),
> . . . . . . . . . . . . >                 l_orderkey,
> . . . . . . . . . . . . >                 l_partkey
> . . . . . . . . . . . . >         from    cp.`tpch/lineitem.parquet`
> . . . . . . . . . . . . >         group by
> . . . . . . . . . . . . >                 l_orderkey,
> . . . . . . . . . . . . >                 l_partkey
> . . . . . . . . . . . . >         )
> . . . . . . . . . . . . > group by
> . . . . . . . . . . . . >         cast(l_orderkey as varchar(10)) || '-' || cast(l_partkey
as varchar(10));
> Query failed: Query failed: Failure while running fragment., You tried to do a batch
data read operation when you were in a state of STOP.  You can only do this type of operation
when you are in a state of OK or OK_NEW_SCHEMA. [ f5cb68a8-7c05-4e02-a104-56081e6d34ce on
atsqa4-133.qa.lab:31010 ]
> [ f5cb68a8-7c05-4e02-a104-56081e6d34ce on atsqa4-133.qa.lab:31010 ]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message