0 votes
139 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, 2017 by datalab (3,540 points) | 139 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, 2017 by datalab (3,540 points)

97 questions

84 answers

35 comments

430 users

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