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

["Nick Hryhoriev (JIRA)" <ji...@apache.org>]

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

Nick Hryhoriev edited comment on PHOENIX-1953 at 11/22/15 7:31 AM:
-------------------------------------------------------------------

Thanks for link to Duplicate issue, just strange, that duplicate bug have higher number, than my.  Any way now i can convince management that this is phoenix limitation. not bug in our product.


was (Author: hryhoriev.nick):
Thanks for link to Duplicate issue, just strange, that duplicate bug have higher number, than my.  Any way know i can convince management that this is phoenix limitation. not bug in our product.

> 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)