Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@phoenix.apache.org
Date: Thu, 7 May 2015 07:51:00 +0000 (UTC)
From: "Nick Hryhoriev (JIRA)" <jira@apache.org>
To: dev@phoenix.incubator.apache.org
Message-ID: <JIRA.12827700.1430926680000.33619.1430985060629@Atlassian.JIRA>
In-Reply-To: <JIRA.12827700.1430926680000@Atlassian.JIRA>
References: <JIRA.12827700.1430926680000@Atlassian.JIRA>
 <JIRA.12827700.1430926680982@arcas>
Subject: [jira] [Commented] (PHOENIX-1953) Sub Query do bot work for *(all
 column)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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