hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xingwen Zhang (JIRA)" <>
Subject [jira] [Commented] (HIVE-7224) Set incremental printing to true by default in Beeline
Date Fri, 18 Jul 2014 18:00:18 GMT


Xingwen Zhang commented on HIVE-7224:

We would like to report that "--incremental=true" in Beeline is not compatible with Binary
columns (at least for queries like  "select * from some_table_with_a_binary_column limit 10;").
The error trace we got was:
Error: Invalid column type: -2 (state=,code=0)
java.sql.SQLException: Invalid column type: -2
at org.apache.hive.jdbc.JdbcColumn.columnDisplaySize(
at org.apache.hive.jdbc.HiveResultSetMetaData.getColumnDisplaySize(
at org.apache.hive.beeline.IncrementalRows.<init>(
at org.apache.hive.beeline.BeeLine.print(
at org.apache.hive.beeline.Commands.execute(
at org.apache.hive.beeline.Commands.sql(
at org.apache.hive.beeline.BeeLine.dispatch(
at org.apache.hive.beeline.BeeLine.begin(
at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(
at org.apache.hive.beeline.BeeLine.main(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at org.apache.hadoop.util.RunJar.main(

The error was gone when we reverted back to " "--incremental=false".

BTW: we are using Hive 0.12.

> Set incremental printing to true by default in Beeline
> ------------------------------------------------------
>                 Key: HIVE-7224
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>          Components: Clients, JDBC
>    Affects Versions: 0.13.0
>            Reporter: Vaibhav Gumashta
>            Assignee: Vaibhav Gumashta
>             Fix For: 0.14.0
>         Attachments: HIVE-7224.1.patch
> See HIVE-7221.
> By default beeline tries to buffer the entire output relation before printing it on stdout.
This can cause OOM when the output relation is large. However, beeline has the option of incremental
prints. We should keep that as the default.

This message was sent by Atlassian JIRA

View raw message