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