Return-Path: X-Original-To: apmail-hive-issues-archive@minotaur.apache.org Delivered-To: apmail-hive-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8EF6A100F6 for ; Fri, 4 Dec 2015 05:49:11 +0000 (UTC) Received: (qmail 40602 invoked by uid 500); 4 Dec 2015 05:49:11 -0000 Delivered-To: apmail-hive-issues-archive@hive.apache.org Received: (qmail 40582 invoked by uid 500); 4 Dec 2015 05:49:11 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 40562 invoked by uid 99); 4 Dec 2015 05:49:11 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 04 Dec 2015 05:49:11 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 0171A2C033A for ; Fri, 4 Dec 2015 05:49:10 +0000 (UTC) Date: Fri, 4 Dec 2015 05:49:10 +0000 (UTC) From: "Hive QA (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-12578) Hive query failing with error ClassCastException org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc cannot be cast to org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-12578?page=3Dcom.atlassian= .jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1504= 0109#comment-15040109 ]=20 Hive QA commented on HIVE-12578: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12775439/HIVE-12578.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 16 failed/errored test(s), 9875 tests ex= ecuted *Failed tests:* {noformat} TestCliDriver-dynpart_sort_optimization2.q-skewjoin_mapjoin4.q-list_bucket_= dml_6.q-and-12-more - did not produce a TEST-*.xml file TestHWISessionManager - did not produce a TEST-*.xml file org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_cbo_udf_max org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_semijoin org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_subquery_multiinsert org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_subquery_unqual_corr= _expr org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_vector_leftsemi_mapj= oin org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver_dynamic_part= ition_pruning org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver_vectorized_d= ynamic_partition_pruning org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_mergejoin org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vector_leftse= mi_mapjoin org.apache.hadoop.hive.cli.TestNegativeCliDriver.testNegativeCliDriver_auth= orization_uri_import org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_semijoin org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_subquery_multii= nsert org.apache.hadoop.hive.metastore.TestHiveMetaStorePartitionSpecs.testGetPar= titionSpecs_WithAndWithoutPartitionGrouping org.apache.hive.jdbc.TestSSL.testSSLVersion {noformat} Test results: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job= /PreCommit-HIVE-TRUNK-Build/6225/testReport Console output: http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/j= ob/PreCommit-HIVE-TRUNK-Build/6225/console Test logs: http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit= -HIVE-TRUNK-Build-6225/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 16 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12775439 - PreCommit-HIVE-TRUNK-Build > Hive query failing with error ClassCastException org.apache.hadoop.hive.q= l.plan.ExprNodeConstantDesc cannot be cast to org.apache.hadoop.hive.ql.pla= n.ExprNodeColumnDesc > -------------------------------------------------------------------------= ---------------------------------------------------------------------------= -------------------- > > Key: HIVE-12578 > URL: https://issues.apache.org/jira/browse/HIVE-12578 > Project: Hive > Issue Type: Bug > Affects Versions: 2.0.0 > Reporter: Jesus Camacho Rodriguez > Assignee: Jesus Camacho Rodriguez > Attachments: HIVE-12578.patch > > > Two tables: > {noformat} > CREATE TABLE table_1 (boolean_col_1 BOOLEAN, float_col_2 FLOAT, bigint_co= l_3 BIGINT, varchar0111_col_4 VARCHAR(111), bigint_col_5 BIGINT, float_col_= 6 FLOAT, boolean_col_7 BOOLEAN, decimal0101_col_8 DECIMAL(1, 1), decimal090= 4_col_9 DECIMAL(9, 4), char0112_col_10 CHAR(112), double_col_11 DOUBLE, boo= lean_col_12 BOOLEAN, double_col_13 DOUBLE, varchar0142_col_14 VARCHAR(142),= timestamp_col_15 TIMESTAMP, decimal0502_col_16 DECIMAL(5, 2), smallint_col= _25 SMALLINT, decimal3222_col_18 DECIMAL(32, 22), boolean_col_19 BOOLEAN, d= ecimal2012_col_20 DECIMAL(20, 12), char0204_col_21 CHAR(204), double_col_61= DOUBLE, timestamp_col_23 TIMESTAMP, int_col_24 INT, float_col_25 FLOAT, sm= allint_col_26 SMALLINT, double_col_27 DOUBLE, char0180_col_28 CHAR(180), de= cimal1503_col_29 DECIMAL(15, 3), timestamp_col_30 TIMESTAMP, smallint_col_3= 1 SMALLINT, decimal2020_col_32 DECIMAL(20, 20), timestamp_col_33 TIMESTAMP,= boolean_col_34 BOOLEAN, decimal3025_col_35 DECIMAL(30, 25), decimal3117_co= l_36 DECIMAL(31, 17), timestamp_col_37 TIMESTAMP, varchar0146_col_38 VARCHA= R(146), boolean_col_39 BOOLEAN, double_col_40 DOUBLE, float_col_41 FLOAT, t= imestamp_col_42 TIMESTAMP, double_col_43 DOUBLE, boolean_col_44 BOOLEAN, ti= mestamp_col_45 TIMESTAMP, tinyint_col_8 TINYINT, int_col_47 INT, decimal040= 1_col_48 DECIMAL(4, 1), varchar0064_col_49 VARCHAR(64), string_col_50 STRIN= G, double_col_51 DOUBLE, string_col_52 STRING, boolean_col_53 BOOLEAN, int_= col_54 INT, boolean_col_55 BOOLEAN, string_col_56 STRING, double_col_57 DOU= BLE, varchar0131_col_58 VARCHAR(131), boolean_col_59 BOOLEAN, bigint_col_22= BIGINT, char0184_col_61 CHAR(184), varchar0173_col_62 VARCHAR(173), timest= amp_col_63 TIMESTAMP, decimal1709_col_26 DECIMAL(20, 5), timestamp_col_65 T= IMESTAMP, timestamp_col_66 TIMESTAMP, timestamp_col_67 TIMESTAMP, boolean_c= ol_68 BOOLEAN, decimal1208_col_20 DECIMAL(33, 11), decimal1605_col_70 DECIM= AL(16, 5), varchar0010_col_71 VARCHAR(10), tinyint_col_72 TINYINT, timestam= p_col_10 TIMESTAMP, decimal2714_col_74 DECIMAL(27, 14), double_col_75 DOUBL= E, boolean_col_76 BOOLEAN, double_col_77 DOUBLE, string_col_78 STRING, bool= ean_col_79 BOOLEAN, boolean_col_80 BOOLEAN, decimal0803_col_81 DECIMAL(8, 3= ), decimal1303_col_82 DECIMAL(13, 3), tinyint_col_83 TINYINT, decimal3424_c= ol_84 DECIMAL(34, 24), float_col_85 FLOAT, boolean_col_86 BOOLEAN, char0233= _col_87 CHAR(233)); > CREATE TABLE table_18 (timestamp_col_1 TIMESTAMP, double_col_2 DOUBLE, bo= olean_col_3 BOOLEAN, timestamp_col_4 TIMESTAMP, decimal2103_col_5 DECIMAL(2= 1, 3), char0221_col_6 CHAR(221), tinyint_col_7 TINYINT, float_col_8 FLOAT, = int_col_2 INT, timestamp_col_10 TIMESTAMP, char0228_col_11 CHAR(228), times= tamp_col_12 TIMESTAMP, double_col_13 DOUBLE, tinyint_col_6 TINYINT, tinyint= _col_33 TINYINT, smallint_col_38 SMALLINT, boolean_col_17 BOOLEAN, double_c= ol_18 DOUBLE, boolean_col_19 BOOLEAN, bigint_col_20 BIGINT, decimal0504_col= _37 DECIMAL(37, 34), boolean_col_22 BOOLEAN, double_col_23 DOUBLE, timestam= p_col_24 TIMESTAMP, varchar0076_col_25 VARCHAR(76), timestamp_col_18 TIMEST= AMP, boolean_col_27 BOOLEAN, decimal1611_col_22 DECIMAL(37, 5), boolean_col= _29 BOOLEAN); > {noformat} > Query: > {noformat} > SELECT > COALESCE(498, LEAD(COALESCE(-973, -684, 515)) OVER (PARTITION BY (t2.int_= col_2 + t1.smallint_col_25) ORDER BY (t2.int_col_2 + t1.smallint_col_25), F= LOOR(t1.double_col_61) DESC), 524) AS int_col, > (t2.int_col_2) + (t1.smallint_col_25) AS int_col_1, > FLOOR(t1.double_col_61) AS float_col, > COALESCE(SUM(COALESCE(62, -380, -435)) OVER (PARTITION BY (t2.int_col_2 += t1.smallint_col_25) ORDER BY (t2.int_col_2 + t1.smallint_col_25) DESC, FLO= OR(t1.double_col_61) DESC ROWS BETWEEN UNBOUNDED PRECEDING AND 48 FOLLOWING= ), 704) AS int_col_2 > FROM table_1 t1 > INNER JOIN table_18 t2 ON (((t2.tinyint_col_6) =3D (t1.bigint_col_22)) AN= D ((t2.decimal0504_col_37) =3D (t1.decimal1709_col_26))) AND ((t2.tinyint_c= ol_33) =3D (t1.tinyint_col_8)) > WHERE > (t2.smallint_col_38) IN (SELECT > COALESCE(-92, -994) AS int_col > FROM table_1 tt1 > INNER JOIN table_18 tt2 ON (tt2.decimal1611_col_22) =3D (tt1.decimal1208_= col_20) > WHERE > (t1.timestamp_col_10) =3D (tt2.timestamp_col_18)); > {noformat} > We get the following error: > {noformat} > ClassCastException org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc ca= nnot be cast to org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc > {noformat} > We need to add support for constants in Select clause of semijoin subquer= y. -- This message was sent by Atlassian JIRA (v6.3.4#6332)