Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting)

Solved Go to solution
Highlighted

Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting)

Super Guru

Where to store a 672 dimension, million record dataset for online applications?

How would you store it, lay it out. Most queries are working with smaller subsets of the dimensions, say 20-30 at a time.

HBase or HBase + Phoenix has been thought of?

Or would Hive + Tez + ORC work well.

Should it be cached like Apache Ignite? Apache Geode? Redis?

Any suggestions? Looking for best practices for a greenfield application.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting)

Super Guru

Druid is another option and is supported in HDP 2.6

View solution in original post

4 REPLIES 4
Highlighted

Re: Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting)

Super Collaborator

Have you looked at Apache Kylin (which is built on top of hbase) ?

http://kylin.apache.org/

Highlighted

Re: Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting)

Super Collaborator
Highlighted

Re: Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting)

Super Guru

is Kylin a support part of the HDP 2.4 stack?

Highlighted

Re: Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting)

Super Guru

Druid is another option and is supported in HDP 2.6

View solution in original post

Don't have an account?
Coming from Hortonworks? Activate your account here