[jira] [Commented] (PHOENIX-1953) Sub Query do not work for *(all column)

["James Taylor (JIRA)" <ji...@apache.org>]

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

James Taylor commented on PHOENIX-1953:
---------------------------------------

You're right, [~hryhoriev.nick] - I could have sworn I already had a bug for this limitations when I saw yours, but I never could find it. Hence the new bug with a higher number. We can dup that one against this one, but it's the same difference. FWIW, we're in the process of integrating with Apache Calcite at which point this issue will be resolved.

> Sub Query do not work for *(all column)
> ---------------------------------------
>
>                 Key: PHOENIX-1953
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1953
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.3.0
>            Reporter: Nick Hryhoriev
>
>  preview query: select * from EC.AUTO_DATA as ds limit 10 
>  preview query: select * from (SELECT * FROM ec.auto_data) as ds limit 10 
> This two query is good enough
> select min(ds."SALE_DATE") as "SALE_DATE_min", max(ds."SALE_DATE") as "SALE_DATE_max", sum(case when ds."SALE_DATE" is null then 1 else 0 end) as "SALE_DATE_nc" from (SELECT * FROM ec.auto_data) as ds
> select * from (SELECT * FROM ec.auto_data) as ds limit 100] 
> but this two not  because of error [ERROR 1001 (42I01): Undefined column family. familyName=DS.null]
> and if i change in any of this query * to all column (columnName, columnName, ...) then every thing will work good
> DDL  ->
> Date                    DATETIME or TIMESTAMP, 
> State                   VARCHAR(20), 
> `County Code`           VARCHAR(15), 
> `Income Bracket`        VARCHAR(17), 
> sale_date               BIGINT, 
> ship_date               DATETIME or TIMESTAMP, 
> Sales                   DECIMAL, NUMERIC, or FLOAT, 
> Zipcode                 VARCHAR(15), 
> `Product Category`      VARCHAR(15), 
> City                    VARCHAR(25), 
> `Product Group`         VARCHAR(11), 
> Satisfaction            INTEGER, 
> SKU                     VARCHAR(8), 
> `Planned Sales`         DECIMAL, NUMERIC, or FLOAT, 
> Gender                  VARCHAR(6),  
> County                  VARCHAR(31),
> `Review Text`           VARCHAR(16000) or TEXT



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)