phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nick Hryhoriev (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-1953) Sub Query do bot work for *(all column)
Date Thu, 07 May 2015 07:51:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-1953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14532194#comment-14532194
] 

Nick Hryhoriev commented on PHOENIX-1953:
-----------------------------------------

Sorry James, duplicate of what?
 where i can find any remarks about this problem?

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

Mime
View raw message