[ https://issues.apache.org/jira/browse/PHOENIX-1953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Taylor resolved PHOENIX-1953. ----------------------------------- Resolution: Duplicate Duplicate of PHOENIX-1953 > 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 > 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)