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

[Nick Hryhoriev (JIRA)]

Nick Hryhoriev created PHOENIX-1953:
---------------------------------------

             Summary: Sub Query do bot 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




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