Re: Advice wanted on supporting a tag feature for searching an HBase Table via Phoenix

2021-02-22 Thread Simon Mottram
Hey Josh Thanks much for the feedback. Sounds good S From: Josh Elser Sent: 23 February 2021 9:14 AM To: user@phoenix.apache.org Subject: Re: Advice wanted on supporting a tag feature for searching an HBase Table via Phoenix I had a similar sort of issues

Re: Advice wanted on supporting a tag feature for searching an HBase Table via Phoenix

2021-02-22 Thread Josh Elser
I had a similar sort of issues (granted, less data scale), and I went with option 2. If you put the rowkey of your "data" table plus the tag itself into the rowkey for your other table/index, you should be able to grow without running into HBase scalability (though, pulling 10GB of tags for

Advice wanted on supporting a tag feature for searching an HBase Table via Phoenix

2021-02-21 Thread Simon Mottram
The requirement is to be able to search from a list of tags, each record can have a possible large number of tags. There would be more than one tag field. An example might 3 different hashtag fields. They do have to be different; we can't have just one tag cloud. The data size is large so we