You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2015/11/22 06:22:11 UTC
[jira] [Updated] (PHOENIX-1953) Sub Query do not work for *(all
column)
[ 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)