![]() |
Hello,
I have the following two questions please:
07 Sep 2016
,
|
![]() |
If I create a volatile table with the following SQL codes:
19 May 2015
| 2 comments
,
|
![]() |
Hi!. I have the following query: create multiset volatile table newTable, no log as ( SELECT so.*, pu.* FROM db.table1 so left outer join db.table2 pu on so.id = pu.id ) with data primary index(id) on commit preserve rows; Which throws the following error when run:
08 Apr 2015
| 1 comment
,
|
![]() |
Hi,
26 Mar 2015
| 2 comments
,
|
![]() |
Hi,
01 Apr 2014
| 3 comments
,
|
![]() |
How to create auto generated ID in volatile table?
25 Mar 2014
| 5 comments
,
|
![]() |
Hi-
26 Jul 2013
| 1 comment
,
|
![]() |
Hi Experts,
10 Jul 2013
| 1 comment
,
|
![]() |
Hi All, I am trying to create a volatile table by selecting data from an existing table. However, when I execute the CREATE TABLE query, I get the following error. CREATE TABLE failed. Please do not resubmit this query. Crashcode 3701. How to resolve this?
05 Mar 2013
| 2 comments
,
|
![]() |
|
![]() |
Guys,
Playing with some engine designs that require volatile tables structures based on existing tables structures on a system. The number of unique table structures is very high, so minimal customization should be required or it becomes a sustainability problem. Very simple example:
01 Sep 2012
| 16 comments
,
|
![]() |
Hi, A query having a join with volatile table TMP_TEXT_CONSOLIDATED TEXT1, query is not throwing any error if volatile table doesn’t exist. any idea which table the query referring? Thanks, Karthik. N
16 Apr 2012
| 5 comments
,
|
![]() |
has anyone else come across this? on version 13.00.01.04, release 13.00.01.03 CREATE VOLATILE TABLE test(col1 INTEGER) COLLECT STATS --help stats test; INSERT INTO test (1); --HELP STATS test; COLLECT STATS ON test; --HELP STATS test; CREATE VOLATILE TABLE test2(col1 INTEGER) COLLECT STATS HELP STATS test2; INSERT INTO test2 SELECT col1 FROM test; HELP STATS test2;
06 Dec 2011
| 5 comments
,
|
![]() |
Hi, when I try to create a volatile table through the execution of the following SQL instruction
CREATE VOLATILE TABLE EXPECTED_PROD_DIV_COUPLES AS ( SELECT product_cd, institute_cd FROM MY_DATABASE.MY_TABLE WHERE
23 Nov 2011
| 1 comment
,
|
![]() |
How do i Extract the Data From a volatile table that i have just created
27 Sep 2011
| 2 comments
,
|
![]() |
When you create a VOLATILE TABLE what location is it created in? I know it is a temp table that is gone when the session ends. The following SQL will give me the SQL that was used to create the table:
06 Jul 2011
| 7 comments
,
|
![]() |
I have created a volatile table with table name TEMP1 When I do a show or help or select on table TEMP1 But when I am doing an update or insert like Update DATABASENAME.TABLE2 I am getting an ambiguous error on the TABLE , ambiguous between permanent table DATABASENAME.TEMP1 and volatile table TEMP1
20 Jul 2010
| 4 comments
,
|