[
https://issues.apache.org/jira/browse/HIVE-29?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12652078#action_12652078
]
David Phillips commented on HIVE-29:
------------------------------------
The example script from section 3.5:
{noformat}
E = EXTRACT query
FROM @@logfile@@
USING LogExtractor ;
EXPORT
R = SELECT query, COUNT() AS count
FROM E
GROUP BY query
HAVING count > @@mincount@@;
{noformat}
Using the above script:
{noformat}
Q1 = IMPORT "MyView.script"
PARAMS logfile="Queries_Jan.log",
limit=1000 ;
Q2 = IMPORT "MyView.script"
PARAMS logfile="Queries_Feb.log",
limit=1000 ;
JQ = SELECT Q1.query, Q2.count-Q1.count AS diff,
Q1.count AS jan_cnt,
Q2.count AS feb_count,
FROM Q1 LEFT OUTER JOIN Q2
ON Q1.query == Q2.query
ORDER BY diff DESC;
{noformat}
> Add functionality similar to SCOPE's "virtual" views to Hive
> ------------------------------------------------------------
>
> Key: HIVE-29
> URL: https://issues.apache.org/jira/browse/HIVE-29
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Jeff Hammerbacher
>
> SCOPE has many nice features, and the ability to IMPORT/EXPORT parameterized
> scripts and store partial queries in named variables is one of them. Section
> 3.5 of the SCOPE paper has the details, and there are several examples
> throughout the paper. Perhaps we can choose an alternative delimiter for
> PARAMTER imports, however (SCOPE uses "@@...@@").
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
