question Re: Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting) in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/Optimal-Location-to-Store-for-Interactive-Retrieval-in-a/m-p/131403#M31386 <P>Druid is another option and is supported in HDP 2.6</P> Thu, 23 Nov 2017 00:45:10 GMT TimothySpann 2017-11-23T00:45:10Z Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting) https://community.cloudera.com/t5/Archives-of-Support-Questions/Optimal-Location-to-Store-for-Interactive-Retrieval-in-a/m-p/131399#M31382 <P>Where to store a 672 dimension, million record dataset for online applications?</P><P>How would you store it, lay it out. Most queries are working with smaller subsets of the dimensions, say 20-30 at a time.</P><P>HBase or HBase + Phoenix has been thought of?</P><P>Or would Hive + Tez + ORC work well.</P><P>Should it be cached like Apache Ignite? Apache Geode? Redis?</P><P>Any suggestions? Looking for best practices for a greenfield application.</P> Fri, 10 Jun 2016 03:37:22 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Optimal-Location-to-Store-for-Interactive-Retrieval-in-a/m-p/131399#M31382 TimothySpann 2016-06-10T03:37:22Z Re: Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting) https://community.cloudera.com/t5/Archives-of-Support-Questions/Optimal-Location-to-Store-for-Interactive-Retrieval-in-a/m-p/131400#M31383 <P>Have you looked at Apache Kylin (which is built on top of hbase) ?</P><P><A href="http://kylin.apache.org/" target="_blank">http://kylin.apache.org/</A></P> Fri, 10 Jun 2016 03:54:37 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Optimal-Location-to-Store-for-Interactive-Retrieval-in-a/m-p/131400#M31383 tyu 2016-06-10T03:54:37Z Re: Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting) https://community.cloudera.com/t5/Archives-of-Support-Questions/Optimal-Location-to-Store-for-Interactive-Retrieval-in-a/m-p/131401#M31384 <P>See also</P><P><A href="http://kylin.apache.org/docs15/gettingstarted/best_practices.html">http://kylin.apache.org/docs15/gettingstarted/best_practices.html</A></P> Fri, 10 Jun 2016 03:59:23 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Optimal-Location-to-Store-for-Interactive-Retrieval-in-a/m-p/131401#M31384 tyu 2016-06-10T03:59:23Z Re: Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting) https://community.cloudera.com/t5/Archives-of-Support-Questions/Optimal-Location-to-Store-for-Interactive-Retrieval-in-a/m-p/131402#M31385 <P>is Kylin a support part of the HDP 2.4 stack?</P> Fri, 10 Jun 2016 09:49:30 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Optimal-Location-to-Store-for-Interactive-Retrieval-in-a/m-p/131402#M31385 TimothySpann 2016-06-10T09:49:30Z Re: Optimal Location to Store for Interactive Retrieval in a Modern Data Web Application (and also ad-hoc reporting) https://community.cloudera.com/t5/Archives-of-Support-Questions/Optimal-Location-to-Store-for-Interactive-Retrieval-in-a/m-p/131403#M31386 <P>Druid is another option and is supported in HDP 2.6</P> Thu, 23 Nov 2017 00:45:10 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Optimal-Location-to-Store-for-Interactive-Retrieval-in-a/m-p/131403#M31386 TimothySpann 2017-11-23T00:45:10Z