Return-Path: Delivered-To: apmail-hadoop-hive-dev-archive@minotaur.apache.org Received: (qmail 85007 invoked from network); 8 Aug 2009 03:58:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 8 Aug 2009 03:58:31 -0000 Received: (qmail 56770 invoked by uid 500); 8 Aug 2009 03:58:39 -0000 Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org Received: (qmail 56703 invoked by uid 500); 8 Aug 2009 03:58:38 -0000 Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hadoop.apache.org Delivered-To: mailing list hive-dev@hadoop.apache.org Received: (qmail 56693 invoked by uid 99); 8 Aug 2009 03:58:38 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 08 Aug 2009 03:58:38 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 08 Aug 2009 03:58:35 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id C59FF234C004 for ; Fri, 7 Aug 2009 20:58:14 -0700 (PDT) Message-ID: <1462723159.1249703894795.JavaMail.jira@brutus> Date: Fri, 7 Aug 2009 20:58:14 -0700 (PDT) From: "Ning Zhang (JIRA)" To: hive-dev@hadoop.apache.org Subject: [jira] Commented: (HIVE-734) problem in dealing with null In-Reply-To: <230294194.1249592534813.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/HIVE-734?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12740834#action_12740834 ] Ning Zhang commented on HIVE-734: --------------------------------- In the failing query, there is no column corresponding to null (select null from tt), so the semantic analyzer doesn't know the type of the NULL, therefore it is VOID type. That's why JavaVoidObjectInspector needs to be created. It is the similar that in (select 2 from tt), An JavaIntegerObjectInspector is needed for the constant 2. > problem in dealing with null > ---------------------------- > > Key: HIVE-734 > URL: https://issues.apache.org/jira/browse/HIVE-734 > 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.