Hi,
Can any one tell me how many no of columns can we use in one table and also i would like to know about using 'IN' operator how many values we can search in parallel?
Thanks & Regards,
Kiran
Max No Of Columns can we use in one table in vertica DB?
Moderator: NorbertKrupa
-
- Newbie
- Posts: 9
- Joined: Tue May 21, 2013 7:09 am
Re: Max No Of Columns can we use in one table in vertica DB?
Hello,
The maximum number of Columns for each table supported by Vertica is 1600.
For IN clause, There is no such limit defined with Vertica, You can try wih at your end.
But recommended is not to overload the IN clause, as this can affect the query perormance badly.
Instead go for Joins or Regular expressions in Vertica
The maximum number of Columns for each table supported by Vertica is 1600.
For IN clause, There is no such limit defined with Vertica, You can try wih at your end.
But recommended is not to overload the IN clause, as this can affect the query perormance badly.
Instead go for Joins or Regular expressions in Vertica
-
- Newbie
- Posts: 9
- Joined: Tue May 21, 2013 7:09 am
Re: Max No Of Columns can we use in one table in vertica DB?
Hi Nnani,
Thanks for your reply.
Best Regards,
Kiran
Thanks for your reply.
Best Regards,
Kiran
-
- Intermediate
- Posts: 87
- Joined: Wed Apr 25, 2012 8:10 am
Re: Max No Of Columns can we use in one table in vertica DB?
Hi, Nani and Kiran...
Thanks for the great information..
By the Way , where you are from..?? Im from Hyderabad..
Regards,
Raj!!
Thanks for the great information..
By the Way , where you are from..?? Im from Hyderabad..
Regards,
Raj!!
Rajasekhar.T|HP ATP Vertica Big Data Solutions V1