0 - 17 of 17 tags for volatile table

Hello, 

 

I have the following two questions please:

 

If I create a volatile table with the following SQL codes:

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:

Hi,
At my workplace I can't create permanent tables, so I have been creating volatible tables as middle steps for joins later on very large data set. 

Hi,
Can some one please tell me, between Volatile table and view, which is better in terms of efficiency, accessbility and use?
What is the difference between them??
Also, can I create a volatile table with same name but using different user ID?

How to create auto generated ID in volatile table?

Hi-
I'm trying to learn how to create a temporary table and am getting this error message
CREATE TABLE Failed 3707: Syntax error, expected something like a name or a Unicode delimited identifier or an 'UDFCALLNAME' keyword between ')' and the 'WITH' keyword.
 
Here is the code. What do I need to fix? Thank you-

 Hi Experts,
I was having a discussion with one of my peer regarding the table size calculation for a VT.  
As VT is not stored in any of the Db and is local to user which is currently logged in. 
As user is also a type of DB so shall we use the below query to get the table size-
select tablename, sum(currentperm)

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?

Hi All,

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: 

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

has anyone else come across this?

on version 13.00.01.04, release 13.00.01.03

CREATE VOLATILE TABLE test(col1 INTEGER)
PRIMARY INDEX(col1)
ON COMMIT PRESERVE ROWS;

COLLECT STATS
COLUMN(col1)
ON test;

--help stats test;

INSERT INTO test (1);

--HELP STATS test;

COLLECT STATS ON test;

--HELP STATS test;

CREATE VOLATILE TABLE test2(col1 INTEGER)
PRIMARY INDEX(col1)
ON COMMIT PRESERVE ROWS;

COLLECT STATS
COLUMN(col1)
ON test2;

HELP STATS test2;

INSERT INTO test2 SELECT col1 FROM test;
-- 1 row inserted

HELP STATS test2;

 

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

How do i Extract the Data From a volatile table that i have just created

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:
Show table myVolatileTableName;

I have created a volatile table with table name TEMP1
And a permanent table DATABASENAME.TEMP1

When I do a show or help or select on table TEMP1
I am able to fetch volatile table TEMP1 results as expected

But when I am doing an update or insert like

Update DATABASENAME.TABLE2
SET PT_COL1 = VT_COL1
FROM TEMP1

I am getting an ambiguous error on the TABLE , ambiguous between permanent table DATABASENAME.TEMP1 and volatile table TEMP1
This error is resolved only if I drop the DATABASENAME.TEMP1 or reframe my update statement