Thanks Amit, currently we are running our application with Solr. We sourcing data from Hadoop to Solr.
Now we have to switch to cloud and all the data in Hadoop is switching to Snowflake. So now from the Solr perspective I have 2 options 1) source data from snowflake to Solr. 2) or directly query in Snow flake for my application. May I know which one is perfect here in the performance perspective. Regards, Bala. On Thu, Apr 21, 2022, 11:22 AM Amit Aggarwal <amit.aggarwa...@gmail.com> wrote: > Hi, > > I think the comparison is wrong, because in snowflake data is organized in > fact and dimension tables while solr is search engine. > > Solr is optimized for full text search while snowflake like dB are used to > run joins, analytic queries. > > To answer your question - no if you are on snowflake , solr is not right > choice at all. > > > > On Thu, 21 Apr 2022, 20:34 Balanathagiri Ayyasamypalanivel, < > bala.cit...@gmail.com> wrote: > > > Thanks David, for your quick response. From the overall article in the > > system, it seems like snowflake little faster than the normal Database > > system, so instead of sourcing the data from snowflake to Solr. > > > > Can we directly query from snowflake via snow sql? > > > > Regards, > > Bala. > > > > On Thu, Apr 21, 2022, 10:36 AM David Hastings < > > hastings.recurs...@gmail.com> > > wrote: > > > > > I dont see how they are comparable. One is a DB, the other is a search > > > engine. There is no overlap aside from Solr indexing data fro > Snowflake > > to > > > search it > > > > > > On Thu, Apr 21, 2022 at 10:21 AM Balanathagiri Ayyasamypalanivel < > > > bala.cit...@gmail.com> wrote: > > > > > > > Hi, > > > > > > > > Any one recently switched from Solr to Snowflake? Or can we have any > > > > comparison chart between the snowflake vs Solr. > > > > > > > > Regards, > > > > Bala. > > > > > > > > > >
