[
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)
