0 votes
364 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?
by datalab (21.9k points) | 364 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.

by datalab (21.9k points)

498 questions

505 answers

497 comments

679 users

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

Categories