Option 1 is the best way to go, option 2 is the easiest option but then you’re limited to database lookups. If that’s fine with you and you don’t need what solr gives then it’s the path of least resistance but also the path to getting complaints from anyone that’s used to solrs abilities
On Thu, Apr 21, 2022 at 3:53 PM Balanathagiri Ayyasamypalanivel < [email protected]> wrote: > 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 <[email protected]> > 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, < > > [email protected]> 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 < > > > [email protected]> > > > 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 < > > > > [email protected]> wrote: > > > > > > > > > Hi, > > > > > > > > > > Any one recently switched from Solr to Snowflake? Or can we have > any > > > > > comparison chart between the snowflake vs Solr. > > > > > > > > > > Regards, > > > > > Bala. > > > > > > > > > > > > > > >
