hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dmitry Tolpeko (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11536) %TYPE and %ROWTYPE attributes in data type declaration
Date Fri, 14 Aug 2015 11:20:45 GMT

    [ https://issues.apache.org/jira/browse/HIVE-11536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696887#comment-14696887
] 

Dmitry Tolpeko commented on HIVE-11536:
---------------------------------------

An example:

{code}
DECLARE
   v src.key%TYPE;
BEGIN
   SELECT key INTO v FROM src LIMIT 1;
   PRINT v;
END
{code}

> %TYPE and %ROWTYPE attributes in data type declaration
> ------------------------------------------------------
>
>                 Key: HIVE-11536
>                 URL: https://issues.apache.org/jira/browse/HIVE-11536
>             Project: Hive
>          Issue Type: Improvement
>          Components: hpl/sql
>            Reporter: Dmitry Tolpeko
>            Assignee: Dmitry Tolpeko
>
> %TYPE and %ROWTYPE attributes allow you to derive the data type from the corresponding
table column. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message