[
https://issues.apache.org/jira/browse/HIVE-11536?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14700951#comment-14700951
]
Dmitry Tolpeko commented on HIVE-11536:
---------------------------------------
%ROWTYPE examples:
{code}
DECLARE
v1 default.src%ROWTYPE;
BEGIN
SELECT key, value INTO v1 FROM src LIMIT 1;
PRINT v1.key || v1.value;
END
{code}
{code}
DECLARE
v1 default.src%ROWTYPE;
CURSOR c1 IS SELECT key, value FROM src;
BEGIN
OPEN c1;
FETCH c1 INTO v1;
PRINT v1.key || v1.value;
CLOSE c1;
END
{code}
{code}
BEGIN
FOR rec IN (SELECT key, value FROM src)
LOOP
PRINT rec.key || rec.value;
END LOOP;
END;
{code}
{code}
DECLARE
v1 default.src%ROWTYPE;
BEGIN
EXECUTE IMMEDIATE 'SELECT key, value FROM src LIMIT 1' INTO v1;
PRINT v1.key || v1.value;
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)
