Return-Path: X-Original-To: apmail-hive-dev-archive@www.apache.org Delivered-To: apmail-hive-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5D81517D96 for ; Sat, 11 Oct 2014 02:10:34 +0000 (UTC) Received: (qmail 67163 invoked by uid 500); 11 Oct 2014 02:10:33 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 67086 invoked by uid 500); 11 Oct 2014 02:10:33 -0000 Mailing-List: contact dev-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 dev@hive.apache.org Received: (qmail 67071 invoked by uid 500); 11 Oct 2014 02:10:33 -0000 Delivered-To: apmail-hadoop-hive-dev@hadoop.apache.org Received: (qmail 67068 invoked by uid 99); 11 Oct 2014 02:10:33 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 11 Oct 2014 02:10:33 +0000 Date: Sat, 11 Oct 2014 02:10:33 +0000 (UTC) From: "Sergey Shelukhin (JIRA)" To: hive-dev@hadoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (HIVE-8433) CBO loses a column during AST conversion MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Sergey Shelukhin created HIVE-8433: -------------------------------------- Summary: CBO loses a column during AST conversion Key: HIVE-8433 URL: https://issues.apache.org/jira/browse/HIVE-8433 Project: Hive Issue Type: Bug Components: CBO Reporter: Sergey Shelukhin Assignee: Sergey Shelukhin Priority: Critical {noformat} SELECT CAST(value AS BINARY), value FROM src ORDER BY value LIMIT 100 {noformat} returns only one column. Final CBO plan is {noformat} HiveSortRel(sort0=[$1], dir0=[ASC]): rowcount = 500.0, cumulative cost = {24858.432393688767 rows, 500.0 cpu, 0.0 io}, id = 44 HiveProjectRel(value=[CAST($0):BINARY(2147483647) NOT NULL], value1=[$0]): rowcount = 500.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io}, id = 42 HiveProjectRel(value=[$1]): rowcount = 500.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io}, id = 40 HiveTableScanRel(table=[[default.src]]): rowcount = 500.0, cumulative cost = {0}, id = 0 {noformat} but the resulting AST has only one column. Must be some bug in converted, probably related to the name collision in the schema, judging by the alias of the column for the binary-cast value in the AST {noformat} TOK_QUERY TOK_FROM TOK_SUBQUERY TOK_QUERY TOK_FROM TOK_TABREF TOK_TABNAME default src src TOK_INSERT TOK_DESTINATION TOK_DIR TOK_TMP_FILE TOK_SELECT TOK_SELEXPR . TOK_TABLE_OR_COL src value value $hdt$_0 TOK_INSERT TOK_DESTINATION TOK_DIR TOK_TMP_FILE TOK_SELECT TOK_SELEXPR TOK_FUNCTION TOK_BINARY . TOK_TABLE_OR_COL $hdt$_0 value value TOK_ORDERBY TOK_TABSORTCOLNAMEASC TOK_TABLE_OR_COL value TOK_LIMIT 100 {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)