The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

regarding data model

edited August 2018 in General Discussion

HI
i had data containing of following fileds

name,email,gender,interests

name is varchar
email is varchar
gender is number
interests is array of integers

total data is 200 million

and interest 200 million * 200

requirement

count should be with in 3 seconds on gender and interest id

Comments

  • Jim_KnicelyJim_Knicely Administrator

    @punnareddy - What exactly are you asking? Can you expand on the "interests" column? What do you mean by an array of INTs? That is, are you talking about an object type or just a string of numbers (i.e. 1, 2, 3) that can be stored in a VARCHAR?

  • hi jim the interset column contains values like (1,3,6,7,8.......uo to 300 values).if i store it as varchar like query is very slow ,so altrnate way of storing plz suggest me

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.