Return-Path: 
 <dev-return-4753-apmail-tajo-dev-archive=tajo.apache.org@tajo.incubator.apache.org>
X-Original-To: apmail-tajo-dev-archive@minotaur.apache.org
Delivered-To: apmail-tajo-dev-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 19FD610F97
	for <apmail-tajo-dev-archive@minotaur.apache.org>;
 Fri, 17 Jan 2014 18:28:42 +0000 (UTC)
Received: (qmail 36269 invoked by uid 500); 17 Jan 2014 18:28:41 -0000
Delivered-To: apmail-tajo-dev-archive@tajo.apache.org
Received: (qmail 36235 invoked by uid 500); 17 Jan 2014 18:28:41 -0000
Mailing-List: contact dev-help@tajo.incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@tajo.incubator.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@tajo.incubator.apache.org>
List-Post: <mailto:dev@tajo.incubator.apache.org>
List-Id: <dev.tajo.incubator.apache.org>
Reply-To: dev@tajo.incubator.apache.org
Delivered-To: mailing list dev@tajo.incubator.apache.org
Received: (qmail 36213 invoked by uid 99); 17 Jan 2014 18:28:40 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Jan 2014 18:28:40 +0000
X-ASF-Spam-Status: No, hits=-2000.1 required=5.0
	tests=ALL_TRUSTED,RP_MATCHES_RCVD
X-Spam-Check-By: apache.org
Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3)
    by apache.org (qpsmtpd/0.29) with SMTP; Fri, 17 Jan 2014 18:28:39 +0000
Received: (qmail 34023 invoked by uid 99); 17 Jan 2014 18:28:19 -0000
Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Jan 2014 18:28:19 +0000
Date: Fri, 17 Jan 2014 18:28:19 +0000 (UTC)
From: "Jaehwa Jung (JIRA)" <jira@apache.org>
To: dev@tajo.incubator.apache.org
Message-ID: <JIRA.12689534.1389983173022.25412.1389983299502@arcas>
In-Reply-To: <JIRA.12689534.1389983173022@arcas>
References: <JIRA.12689534.1389983173022@arcas>
Subject: [jira] [Work started] (TAJO-519) HCatalogStore can't support
 OrderBy clause.
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


     [ https://issues.apache.org/jira/browse/TAJO-519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on TAJO-519 started by Jaehwa Jung.

> HCatalogStore can't support OrderBy clause.
> -------------------------------------------
>
>                 Key: TAJO-519
>                 URL: https://issues.apache.org/jira/browse/TAJO-519
>             Project: Tajo
>          Issue Type: Bug
>          Components: catalog, planner/optimizer
>            Reporter: Jaehwa Jung
>            Assignee: Jaehwa Jung
>
> When I used OrderBy clause, I came across a error as follows:
> {code:xml}
> tajo> \d table1;
> table name: default.table1
> table path: hdfs://localhost:9010/user/hive/warehouse/table1
> store type: CSV
> number of rows: 0
> volume: 60 B
> Options: 
> 	'csvfile.delimiter'='|'
> schema: 
> id	INT4
> name	TEXT
> score	FLOAT4
> type	TEXT
> Partitions: 
> tajo> select * from table1;
> Progress: 0%, response time: 0.951 sec
> Progress: 100%, response time: 1.333 sec
> SLF4J: Class path contains multiple SLF4J bindings.
> SLF4J: Found binding in [jar:file:/Users/blrunner/tajo-0.8.0-SNAPSHOT/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: Found binding in [jar:file:/Users/blrunner/hadoop-2.2.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
> SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
> SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
> 2014-01-18 03:21:26.859 java[59241:1203] Unable to load realm info from SCDynamicStore
> 2014-01-18 03:21:27,380 WARN  util.NativeCodeLoader (NativeCodeLoader.java:<clinit>(62)) - Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
> 2014-01-18 03:21:27,389 WARN  storage.AbstractStorageManager (AbstractStorageManager.java:<init>(86)) - does not support block metadata. ('dfs.datanode.hdfs-blocks-metadata.enabled')
> final state: QUERY_SUCCEEDED, response time: 1.333 sec
> result: file:/tmp/tajo-blrunner/staging/q_1389982867892_0001/RESULT, 5 rows (72 B)
> id,  name,  score,  type
> -------------------------------
> 1,  ooo,  1.1,  a
> 2,  ppp,  2.3,  b
> 3,  qqq,  3.4,  c
> 4,  rrr,  4.5,  d
> 5,  xxx,  5.6,  e
> tajo> select * from table1 order by type;
> Unexpected State: table1.type asc 
> tajo> select id, type from table1 order by type;
> Unexpected State: table1.type asc 
> {code}



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)