You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ning Zhang (JIRA)" <ji...@apache.org> on 2010/09/03 19:56:34 UTC

[jira] Created: (HIVE-1614) UDTF json_tuple should return null row when input is not a valid JSON string

UDTF json_tuple should return null row when input is not a valid JSON string
----------------------------------------------------------------------------

                 Key: HIVE-1614
                 URL: https://issues.apache.org/jira/browse/HIVE-1614
             Project: Hadoop Hive
          Issue Type: Bug
            Reporter: Ning Zhang
            Assignee: Ning Zhang


If the input column is not a valid JSON string, json_tuple will not return anything but this will prevent the downstream operators to access the left-hand side table. We should output a NULL row instead, similar to when the input column is a NULL value. 

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


[jira] Updated: (HIVE-1614) UDTF json_tuple should return null row when input is not a valid JSON string

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Namit Jain updated HIVE-1614:
-----------------------------

           Status: Resolved  (was: Patch Available)
     Hadoop Flags: [Reviewed]
    Fix Version/s: 0.7.0
       Resolution: Fixed

Committed. Thanks Ning

> UDTF json_tuple should return null row when input is not a valid JSON string
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-1614
>                 URL: https://issues.apache.org/jira/browse/HIVE-1614
>             Project: Hadoop Hive
>          Issue Type: Bug
>    Affects Versions: 0.7.0
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>             Fix For: 0.7.0
>
>         Attachments: HIVE-1614.2.patch, HIVE-1614.patch
>
>
> If the input column is not a valid JSON string, json_tuple will not return anything but this will prevent the downstream operators to access the left-hand side table. We should output a NULL row instead, similar to when the input column is a NULL value. 

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


[jira] Commented: (HIVE-1614) UDTF json_tuple should return null row when input is not a valid JSON string

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12906135#action_12906135 ] 

Namit Jain commented on HIVE-1614:
----------------------------------

+1

will commit if the tests pass

> UDTF json_tuple should return null row when input is not a valid JSON string
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-1614
>                 URL: https://issues.apache.org/jira/browse/HIVE-1614
>             Project: Hadoop Hive
>          Issue Type: Bug
>    Affects Versions: 0.7.0
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>         Attachments: HIVE-1614.2.patch, HIVE-1614.patch
>
>
> If the input column is not a valid JSON string, json_tuple will not return anything but this will prevent the downstream operators to access the left-hand side table. We should output a NULL row instead, similar to when the input column is a NULL value. 

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


[jira] Updated: (HIVE-1614) UDTF json_tuple should return null row when input is not a valid JSON string

Posted by "Ning Zhang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ning Zhang updated HIVE-1614:
-----------------------------

    Attachment: HIVE-1614.2.patch

Added a catch for all throwable in the UDFT.

> UDTF json_tuple should return null row when input is not a valid JSON string
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-1614
>                 URL: https://issues.apache.org/jira/browse/HIVE-1614
>             Project: Hadoop Hive
>          Issue Type: Bug
>    Affects Versions: 0.7.0
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>         Attachments: HIVE-1614.2.patch, HIVE-1614.patch
>
>
> If the input column is not a valid JSON string, json_tuple will not return anything but this will prevent the downstream operators to access the left-hand side table. We should output a NULL row instead, similar to when the input column is a NULL value. 

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


[jira] Commented: (HIVE-1614) UDTF json_tuple should return null row when input is not a valid JSON string

Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-1614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12906010#action_12906010 ] 

Namit Jain commented on HIVE-1614:
----------------------------------

I will take a look

> UDTF json_tuple should return null row when input is not a valid JSON string
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-1614
>                 URL: https://issues.apache.org/jira/browse/HIVE-1614
>             Project: Hadoop Hive
>          Issue Type: Bug
>    Affects Versions: 0.7.0
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>         Attachments: HIVE-1614.2.patch, HIVE-1614.patch
>
>
> If the input column is not a valid JSON string, json_tuple will not return anything but this will prevent the downstream operators to access the left-hand side table. We should output a NULL row instead, similar to when the input column is a NULL value. 

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


[jira] Updated: (HIVE-1614) UDTF json_tuple should return null row when input is not a valid JSON string

Posted by "Ning Zhang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ning Zhang updated HIVE-1614:
-----------------------------

    Attachment: HIVE-1614.patch

> UDTF json_tuple should return null row when input is not a valid JSON string
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-1614
>                 URL: https://issues.apache.org/jira/browse/HIVE-1614
>             Project: Hadoop Hive
>          Issue Type: Bug
>    Affects Versions: 0.7.0
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>         Attachments: HIVE-1614.patch
>
>
> If the input column is not a valid JSON string, json_tuple will not return anything but this will prevent the downstream operators to access the left-hand side table. We should output a NULL row instead, similar to when the input column is a NULL value. 

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


[jira] Updated: (HIVE-1614) UDTF json_tuple should return null row when input is not a valid JSON string

Posted by "Ning Zhang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-1614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ning Zhang updated HIVE-1614:
-----------------------------

               Status: Patch Available  (was: Open)
    Affects Version/s: 0.7.0

> UDTF json_tuple should return null row when input is not a valid JSON string
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-1614
>                 URL: https://issues.apache.org/jira/browse/HIVE-1614
>             Project: Hadoop Hive
>          Issue Type: Bug
>    Affects Versions: 0.7.0
>            Reporter: Ning Zhang
>            Assignee: Ning Zhang
>         Attachments: HIVE-1614.patch
>
>
> If the input column is not a valid JSON string, json_tuple will not return anything but this will prevent the downstream operators to access the left-hand side table. We should output a NULL row instead, similar to when the input column is a NULL value. 

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