I have some (1.8 mill documents) stored in the Solr server, I want to do some minimal query stuff in java (using Solrj API) and send the processed data in a table in a sap hana instance . Can anyone please help me ,how can it be possible via java.
As SAP HANA supports JDBC you can take whatever data you have in JAVA and run SQL commands to insert them into SAP HANA like you would with any other JDBC supporting DBMS. This is an answer as specific as possible given your question.