You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@tajo.apache.org by "Jaehwa Jung (JIRA)" <ji...@apache.org> on 2014/01/17 19:28:19 UTC
[jira] [Work started] (TAJO-519) HCatalogStore can't support
OrderBy clause.
[ 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)