[
https://issues.apache.org/jira/browse/DRILL-1199?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mehant Baid resolved DRILL-1199.
--------------------------------
Resolution: Duplicate
> 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: Mehant Baid
> 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)
