drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1199) Order by nested inside a where clause fails
Date Thu, 31 Jul 2014 05:53:45 GMT

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

Jacques Nadeau updated DRILL-1199:
----------------------------------

    Fix Version/s:     (was: 0.4.0)
                   0.5.0

> Order by nested inside a where clause fails
> -------------------------------------------
>
>                 Key: DRILL-1199
>                 URL: https://issues.apache.org/jira/browse/DRILL-1199
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Norris Lee
>            Assignee: Aditya Kishore
>             Fix For: 0.5.0
>
>
> Tableau wraps all Custom SQL queries in a SELECT * FROM ( <query> ) `TableauSQL`
WHERE (0=1)
> If the query contains an order by, the query will fail
> {code}
> 0: jdbc:drill:zk=localhost:5181> select * from (select cast(c_time as time) c_time
from `dfs`.`default`.`opt/drill/raw-files/data` order by c_time) `TableauSQL` where (0=1);
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id:
"250c3758-7254-43d5-b354-ca77f5765876"
> endpoint {
>   address: "192.168.39.43"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Screen received stop request sent. < SchemaChangeException:[ Failure while
attempting to load generated class ] < ClassTransformationException:[ Failure generating
transformation classes for value: 
>  
> package org.apache.drill.exec.test.generated;
> import org.apache.drill.exec.exception.SchemaChangeException;
> import org.apache.drill.exec.ops.FragmentContext;
> import org.apache.drill.exec.record.RecordBatch;
> import org.apache.drill.exec.vector.NullableTimeVector;
> public class CopierGen167 {
>     NullableTimeVector vv0;
>     NullableTimeVector vv3;
>     public boolean doEval(int inIndex, int outIndex)
>         throws SchemaChangeException
>     {
>         {
>             if (!vv3 .copyFromSafe(((inIndex)& 65535), (outIndex), vv0 [((inIndex)>>>
16)])) {
>                 return false;
>             }
>         }
>         {
>             return true;
>         }
>     }
>     public void doSetup(FragmentContext context, RecordBatch incoming, RecordBatch outgoing)
>         throws SchemaChangeException
>     {
>         {
>             int[] fieldIds1 = new int[ 1 ] ;
>             fieldIds1 [ 0 ] = 0;
>             Object tmp2 = (incoming).getValueAccessorById(NullableTimeVector.class, fieldIds1).getValueVector();
>             if (tmp2 == null) {
>                 throw new SchemaChangeException("Failure while loading vector vv0 with
id: org.apache.drill.exec.record.TypedFieldId@6c3316c7.");
>             }
>             vv0 = ((NullableTimeVector) tmp2);
>             int[] fieldIds4 = new int[ 1 ] ;
>             fieldIds4 [ 0 ] = 0;
>             Object tmp5 = (outgoing).getValueAccessorById(NullableTimeVector.class, fieldIds4).getValueVector();
>             if (tmp5 == null) {
>                 throw new SchemaChangeException("Failure while loading vector vv3 with
id: org.apache.drill.exec.record.TypedFieldId@6c3316c7.");
>             }
>             vv3 = ((NullableTimeVector) tmp5);
>         }
>     }
> }
>  ] < CompileException:[ Line 18, Column 36: No applicable constructor/method found
for actual parameters "int, int, java.lang.Object"; candidates are: "public boolean org.apache.drill.exec.vector.NullableTimeVector.copyFromSafe(int,
int, org.apache.drill.exec.vector.TimeVector)", "public boolean org.apache.drill.exec.vector.NullableTimeVector.copyFromSafe(int,
int, org.apache.drill.exec.vector.NullableTimeVector)" ]"
> ]
> Error: exception while executing query (state=,code=0)
> {code}
> The query runs fine without the order by clause.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message