Hi there!
Is it possible to create user defined data types in Vertica? I would like to create a record type to be available as the data type for columns in a table.
Thank you
User defined data type
Moderator: NorbertKrupa
User defined data type
Thank, Fred
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: User defined data type
Hi,
As of release 6.1 we can not create tables that have columns defined as a record type data type.
Is there a reason why you'd want to store data like that in a data warehouse? Maybe look into de-normalizing the data.
Thanks!
As of release 6.1 we can not create tables that have columns defined as a record type data type.
Is there a reason why you'd want to store data like that in a data warehouse? Maybe look into de-normalizing the data.
Thanks!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.