hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <>
Subject [jira] Commented: (HIVE-734) problem in dealing with null
Date Mon, 10 Aug 2009 22:01:15 GMT


Zheng Shao commented on HIVE-734:

Discussed with Ning offline. SemanticAnalyzer.genFileSinkPlan() will be the place for the
change - in case the target is a local/remote directory (instead of a table), when we create
table column names and types, we should use string type if the input is a void type.  Later
in the same function, we are using genConversionSelectOperator() to convert the column types.

So ODBC/JDBC will see this column as string type. Raghu confirmed that MySQL is creating a
table with a column typed "BINARY(0)" when running "CREATE TABLE AS SELECT NULL, ..." 

> problem in dealing with null
> ----------------------------
>                 Key: HIVE-734
>                 URL:
>             Project: Hadoop Hive
>          Issue Type: Bug
>            Reporter: Zheng Shao
>            Assignee: Ning Zhang
> This command fails with the following error:
> {code}
> hive/bin/hive -e "INSERT OVERWRITE LOCAL DIRECTORY 'abc' select null from zshao_tt"
> FAILED: Error in semantic analysis:
> java.lang.RuntimeException: Internal error: Cannot find ObjectInspector for VOID
> {code}
> When 'null' is replaced by '' it works.

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

View raw message