0 votes
19 views
I know some tables are stored by rows in the traditional manner, other have a duplicate table stored by column -- Is there a naming convention or other way to identify which is which?
asked May 28 by datalab (1,810 points) | 19 views

1 Answer

0 votes

Column-store tables will be identified with an "_cs" suffix on the table name.  For example, "ls_dr3.tractor" is the normal row-stored 'tractor' table in the 'ls_dr3' schema, whereas 'ls_dr3.tractor_cs" contains the same information but is column-stored.

answered Oct 5 by datalab (1,810 points)

60 questions

44 answers

0 comments

11 users

Welcome to Data Lab Help Desk, where you can ask questions and receive answers from other members of the community.