Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
AWS re:Postre:Post
Informazioni su re:Post

strange tables names in stv_tbl_perm

0

Hello, I ran this query

select name from stv_tbl_perm where temp = 1 and db_id=101618

And I got the following results :

271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@4872747@9932208@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@4870525@9932568@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29321685@9570081@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29323365@9570716@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29324913@9571277@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@26377403@8951653@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29323903@9571016@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@25415007@8951653@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29326447@9571976@
271020298241:9e77a3c0-58a7-4b33-97da-85bf6241bc48@29309803@9877604@

These table names are not familiar to me, what do they mean? They are temp table created by users?, they are temp tables created by redshift? this format number:text@number@number@ means something?

Argomenti
DatabaseAnalisi
Tag
PostgreSQLAmazon Redshift
Lingua
English
posta 3 anni fa404 visualizzazioni
1 Risposta
0

those are user temporary tables and NOT created by Redshift. system created table during query processing should show up in STV_TBL_TRANS

AWS
ESPERTO
con risposta 3 anni fa
AWS
ESPERTO
verificato 3 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente