Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-519

HCatalogStore can't support OrderBy clause.

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: None
    • Fix Version/s: 0.8.0
    • Component/s: Catalog, Planner/Optimizer
    • Labels:
      None

      Description

      When I used OrderBy clause, I came across a error as follows:

      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 
      

        Activity

        Hide
        blrunner Jaehwa Jung added a comment -

        After I checked out latest source codes from master branch, I can't meet the same error.

        Show
        blrunner Jaehwa Jung added a comment - After I checked out latest source codes from master branch, I can't meet the same error.

          People

          • Assignee:
            blrunner Jaehwa Jung
            Reporter:
            blrunner Jaehwa Jung
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development