tajo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jaehwa Jung (JIRA)" <j...@apache.org>
Subject [jira] [Created] (TAJO-519) HCatalogStore can't support OrderBy clause.
Date Fri, 17 Jan 2014 18:26:23 GMT
Jaehwa Jung created TAJO-519:
--------------------------------

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

Mime
View raw message