hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <j...@apache.org>
Subject [jira] Resolved: (HIVE-274) User cannot specify schema of the script output, only the column names can be specified
Date Mon, 21 Dec 2009 08:56:19 GMT

     [ https://issues.apache.org/jira/browse/HIVE-274?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Zheng Shao resolved HIVE-274.
-----------------------------

    Resolution: Fixed

This is fixed together with HIVE-708

> User cannot specify schema of the script output, only the column names can be specified
> ---------------------------------------------------------------------------------------
>
>                 Key: HIVE-274
>                 URL: https://issues.apache.org/jira/browse/HIVE-274
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>            Reporter: Namit Jain
>
> Consider the test: mapreduce1.q:
> FROM src
> INSERT OVERWRITE TABLE dest1
> MAP src.key, CAST(src.key / 10 AS INT), CAST(src.key % 10 AS INT), src.value
> USING '/bin/cat' AS (tkey, ten, one, tvalue)
> DISTRIBUTE BY tvalue, tkey
> SORT BY ten, one;
> Although, in the MAP input, the user is casting the inputs as INT (ten, one), the reduce
output ('/bin/cat') still treats them as string, and the sorting happens assuming them as
strings - even if the
> user wanted to have integer sorting, the output has lexicographic sorting (look at the
output mapreduce1.q.out).
> In the AS, the user should be able to specify the schema in the same way as CREATE TABLE.

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


Mime
View raw message