0 votes
278 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 (20.7k points) | 278 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 (20.7k points)

418 questions

435 answers

440 comments

637 users

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

Categories