[jira] [Commented] (HIVE-238) complex columns are not handled properly in cluster by, distributed by, sort by clauses and in some select clauses

["Steven Willis (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14000078#comment-14000078 ] 

Steven Willis commented on HIVE-238:
------------------------------------

I'm coming from HIVE-4251 and I found that creating an index on a subfield fails as well:

{noformat}
CREATE INDEX domainIndex
ON TABLE clicks(url.domain)
AS 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler'
WITH DEFERRED REBUILD;
{noformat}

You get:

{noformat}
FAILED: ParseException line 2:19 mismatched input '.' expecting ) near 'url' in create index statement
{noformat}

And there's no work-around that will work here. I think this also affects  {{CLUSTERED BY}}, {{SORTED BY}}, and {{SKEWED BY}} in the {{CREATE TABLE}} statement. I wonder if this is just a parser issue rather than an actual functionality issue.

> complex columns are not handled properly in cluster by, distributed by, sort by clauses and in some select clauses
> ------------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-238
>                 URL: https://issues.apache.org/jira/browse/HIVE-238
>             Project: Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.3.0
>            Reporter: Prasad Chakka
>            Assignee: Ashish Thusoo
>
> if a column is complex then the sub fields can't be referenced in cluster by, distributed by, sort by clauses
> for example if column c1 is an object with attributes a and b then the following query returns an error
> select * from t1 cluster by t1.c1.a (or similar queries)
> also the following query will return an error because current code doesn't distinguish between a complex column or a table alias.
> select c1.a from t1



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