0 votes
36 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,230 points) | 36 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,230 points)

65 questions

48 answers

0 comments

11 users

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