0 votes
45 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 (2,810 points) | 45 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 (2,810 points)

74 questions

57 answers

4 comments

72 users

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