[
https://issues.apache.org/jira/browse/HIVE-7224?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14066639#comment-14066639
]
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(JdbcColumn.java:94)
at
org.apache.hive.jdbc.HiveResultSetMetaData.getColumnDisplaySize(HiveResultSetMetaData.java:60)
at org.apache.hive.beeline.IncrementalRows.<init>(IncrementalRows.java:55)
at org.apache.hive.beeline.BeeLine.print(BeeLine.java:1570)
at org.apache.hive.beeline.Commands.execute(Commands.java:745)
at org.apache.hive.beeline.Commands.sql(Commands.java:657)
at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:794)
at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:661)
at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:366)
at org.apache.hive.beeline.BeeLine.main(BeeLine.java:349)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.apache.hadoop.util.RunJar.main(RunJar.java:208)
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: https://issues.apache.org/jira/browse/HIVE-7224
> 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
(v6.2#6252)
