You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zheng Shao (JIRA)" <ji...@apache.org> on 2009/05/01 09:09:30 UTC

[jira] Updated: (HIVE-466) Fix queries like "SELECT t.*, t.a"

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

Zheng Shao updated HIVE-466:
----------------------------

    Attachment: HIVE-466.1.patch

This includes some fixed tests, as well as a new test.

The genSelectPlan() method is refactored so that we removed the duplicate code for processing of the expressions in "select" and "select transform". This makes future changes much easier (e.g., HIVE-240).


> Fix queries like "SELECT t.*, t.a"
> ----------------------------------
>
>                 Key: HIVE-466
>                 URL: https://issues.apache.org/jira/browse/HIVE-466
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.3.1, 0.4.0
>            Reporter: Zheng Shao
>            Assignee: Zheng Shao
>             Fix For: 0.4.0
>
>         Attachments: HIVE-466.1.patch
>
>
> There was a bug in the SemanticAnalyzer that adds the columnID for one more time for "*".
> This causes queries like this to fail:
> {code}
> create table zshao_lazy (a int);
> // load one row of data into zshao_lazy
> select * from (select *, a as a2 from zshao_lazy) z order by a2 limit 10;
> {code}
> The query will fail at execution time.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.