If your application already talks to solr, Then continuing that will mean the application doesn't need to change, and probably solr needs few or no changes (unless you are also upgrading, moving or improving things in solr at the same time). The process that moved data from hadoop to solr will likely need to be rewritten to talk to snowflake, but if you don't change the type of data available, that process should be able to build a Json structure, or SolrInputDocument (if in java) with all the same fields as before. It's usually harder to change multiple levels of architecture at once so you very likely want #1
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. > > > > > > > > > > > > > > > -- http://www.needhamsoftware.com (work) http://www.the111shift.com (play)
