0 votes
81 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,060 points) | 81 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,060 points)

82 questions

65 answers

13 comments

288 users

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