You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "S. Alex Smith (JIRA)" <ji...@apache.org> on 2008/12/11 02:00:46 UTC

[jira] Created: (HIVE-154) Can't group by tinyints

Can't group by tinyints
-----------------------

                 Key: HIVE-154
                 URL: https://issues.apache.org/jira/browse/HIVE-154
             Project: Hadoop Hive
          Issue Type: Bug
          Components: Query Processor
            Reporter: S. Alex Smith
            Priority: Minor


Attempting to group by tiny ints is considered okay by the CLI, but there's a run time error on the server side giving:
java.lang.RuntimeException: org.apache.hadoop.hive.serde2.SerDeException: org.apache.hadoop.hive.serde2.dynamic_type.ParseException: Encountered "byte" at line 1, column 32.
Was expecting one of:
    "bool" ...
    "i16" ...
    "i32" ...
    "i64" ...
    "double" ...
    "string" ...
    "map" ...
    "list" ...
    "set" ...
    "required" ...
    "optional" ...
    "skip" ...
     ...
     ...
    "}" ...
    
	at org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.initialize(ReduceSinkOperator.java:108)
	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:190)
	at org.apache.hadoop.hive.ql.exec.FilterOperator.initialize(FilterOperator.java:49)
	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:190)
	at org.apache.hadoop.hive.ql.exec.SelectOperator.initialize(SelectOperator.java:48)
	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:190)
	at org.apache.hadoop.hive.ql.exec.TableScanOperator.initialize(TableScanOperator.java:36)
	at org.apache.hadoop.hive.ql.exec.MapOperator.initialize(MapOperator.java:166)
	at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:57)
	at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:47)
	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:220)
	at org.apache.hadoop.mapred.TaskTracker$Child.main(TaskTracker.java:2139)
Caused by: org.apache.hadoop.hive.serde2.SerDeException: org.apache.hadoop.hive.serde2.dynamic_type.ParseException: Encountered "byte" at line 1, column 32.

This can be worked around by casting tinyints as ints.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (HIVE-154) Can't group by tinyints

Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-154?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashish Thusoo updated HIVE-154:
-------------------------------

    Priority: Critical  (was: Minor)

> Can't group by tinyints
> -----------------------
>
>                 Key: HIVE-154
>                 URL: https://issues.apache.org/jira/browse/HIVE-154
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: S. Alex Smith
>            Priority: Critical
>
> Attempting to group by tiny ints is considered okay by the CLI, but there's a run time error on the server side giving:
> java.lang.RuntimeException: org.apache.hadoop.hive.serde2.SerDeException: org.apache.hadoop.hive.serde2.dynamic_type.ParseException: Encountered "byte" at line 1, column 32.
> Was expecting one of:
>     "bool" ...
>     "i16" ...
>     "i32" ...
>     "i64" ...
>     "double" ...
>     "string" ...
>     "map" ...
>     "list" ...
>     "set" ...
>     "required" ...
>     "optional" ...
>     "skip" ...
>      ...
>      ...
>     "}" ...
>     
> 	at org.apache.hadoop.hive.ql.exec.ReduceSinkOperator.initialize(ReduceSinkOperator.java:108)
> 	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:190)
> 	at org.apache.hadoop.hive.ql.exec.FilterOperator.initialize(FilterOperator.java:49)
> 	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:190)
> 	at org.apache.hadoop.hive.ql.exec.SelectOperator.initialize(SelectOperator.java:48)
> 	at org.apache.hadoop.hive.ql.exec.Operator.initialize(Operator.java:190)
> 	at org.apache.hadoop.hive.ql.exec.TableScanOperator.initialize(TableScanOperator.java:36)
> 	at org.apache.hadoop.hive.ql.exec.MapOperator.initialize(MapOperator.java:166)
> 	at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:57)
> 	at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:47)
> 	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:220)
> 	at org.apache.hadoop.mapred.TaskTracker$Child.main(TaskTracker.java:2139)
> Caused by: org.apache.hadoop.hive.serde2.SerDeException: org.apache.hadoop.hive.serde2.dynamic_type.ParseException: Encountered "byte" at line 1, column 32.
> This can be worked around by casting tinyints as ints.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.