[
https://issues.apache.org/jira/browse/PHOENIX-1953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-1953:
----------------------------------
Summary: Sub Query do not work for *(all column) (was: Sub Query do bot
work for *(all column))
> 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)
