[
https://issues.apache.org/jira/browse/HIVE-7090?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jason Dere updated HIVE-7090:
-----------------------------
Attachment: HIVE-7090.5.patch
Patch v5. The show create table tests were failing due to formatting (1 space
difference) change in show create table, updated the diffs.
stats19.q was failing because the scratchdir changes included adding the
session ID to the path, which cause some pathnames to exceed the max prefix
length used in the tests. Test seems a bit fragile since it's dependent on the
path length of the build directory, but increasing the max prefix length before
hashing should get this to pass.
> Support session-level temporary tables in Hive
> ----------------------------------------------
>
> Key: HIVE-7090
> URL: https://issues.apache.org/jira/browse/HIVE-7090
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Reporter: Gunther Hagleitner
> Assignee: Jason Dere
> Attachments: HIVE-7090.1.patch, HIVE-7090.2.patch, HIVE-7090.3.patch,
> HIVE-7090.4.patch, HIVE-7090.5.patch
>
>
> It's common to see sql scripts that create some temporary table as an
> intermediate result, run some additional queries against it and then clean up
> at the end.
> We should support temporary tables properly, meaning automatically manage the
> life cycle and make sure the visibility is restricted to the creating
> connection/session. Without these it's common to see left over tables in
> meta-store or weird errors with clashing tmp table names.
> Proposed syntax:
> CREATE TEMPORARY TABLE ....
> CTAS, CTL, INSERT INTO, should all be supported as usual.
> Knowing that a user wants a temp table can enable us to further optimize
> access to it. E.g.: temp tables should be kept in memory where possible,
> compactions and merging table files aren't required, ...
--
This message was sent by Atlassian JIRA
(v6.2#6252)
