We are planning to load data into two tables, one flex, one 'traditional'.
Would it be possible to do joins, group by's, and other SQL functions with a flex and 'traditional' table?
Thank you!
Search found 2 matches
- Thu May 21, 2015 9:12 pm
- Forum: Vertica SQL
- Topic: Joins, group by, etc with Flex?
- Replies: 3
- Views: 7673
- Thu May 21, 2015 9:11 pm
- Forum: Vertica Data Load
- Topic: Can Vertica Flex handle a 3000 column table with 300 char column names?
- Replies: 2
- Views: 15877
Can Vertica Flex handle a 3000 column table with 300 char column names?
We have some 3rd party marketing data that have up to 3000 columns, and column names up to 300 characters. We would love to load this data into Vertica, and join/group with other tables. Since Vertica itself has a 1600 max number of columns and 100 something byte column name limit, would Flex be abl...