[HIVE-7448] --incremental=true in Beeline is not compatible with Binary columns (at least for select * from ...)

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.12.0
• Fix Version/s: 0.13.0
• Component/s: Clients
• Assignee: Unassigned
• Reporter: Xingwen Zhang
• Created: 18/Jul/14 20:51
• Updated: 12/Oct/14 01:47
• Resolved: 21/Jul/14 04:41

Description

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.

Issue Links

• duplicates: HIVE-3611 Hive JDBC doesn't support BINARY column
• relates to: HIVE-7224 Set incremental printing to true by default in Beeline