You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by Venkata Bhagavatula <ve...@gmail.com> on 2018/04/06 05:35:54 UTC

Ignite with hive as 3rdparty persistence

Hi,

We want to use hive as a 3rd party persistence for ignite. To achieve this
can you let us know how to take it forward. From the documentation, i
understand that we need to implement the CacheStore interface for achieving
this.

How can we make it generic enough irrespective of any schema?
We came to know that Hadoop accelerator is not to be used.

A quick response is highly appreciated.

Thanks n Regards,
Chalapathi.

Re: Ignite with hive as 3rdparty persistence

Posted by Venkata Bhagavatula <ve...@gmail.com>.

Hi Andrei,

Thanks , we will try and get back to you.

Regards,
Chalapathi.

On Fri, Apr 6, 2018 at 2:16 PM, aealexsandrov <ae...@gmail.com>
wrote:

> Hi,
>
> You can describe your own cacheConfiguration as follow:
>
> <bean id= "simpleDataSource" class="%HIVE_JDBC_DRIVER%"/>
>
> <bean id="ignite.cfg"
> class="org.apache.ignite.configuration.IgniteConfiguration">
>   ...
>     <property name="cacheConfiguration">
>       <list>
>         <bean class="org.apache.ignite.configuration.CacheConfiguration">
>           ...
>             <property name="cacheStoreFactory">
>               <bean
> class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
>                 <property name="dataSourceBean" value = "simpleDataSource"
> />
>               </bean>
>             </property>
>         </bean>
>       </list>
>     </property>
> </bean>
>
> %HIVE_JDBC_DRIVER% you can find here:
>
> https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.4/
> bk_data-access/content/hive-jdbc-odbc-drivers.html
>
> For more information read next:
>
> https://apacheignite.readme.io/docs/3rd-party-store
>
> Best Regards,
> Andrei
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Ignite with hive as 3rdparty persistence

Posted by aealexsandrov <ae...@gmail.com>.

Hi,

You can describe your own cacheConfiguration as follow:

<bean id= "simpleDataSource" class="%HIVE_JDBC_DRIVER%"/>
  
<bean id="ignite.cfg"
class="org.apache.ignite.configuration.IgniteConfiguration">
  ...
    <property name="cacheConfiguration">
      <list>
        <bean class="org.apache.ignite.configuration.CacheConfiguration">
          ...
            <property name="cacheStoreFactory">
              <bean
class="org.apache.ignite.cache.store.jdbc.CacheJdbcPojoStoreFactory">
                <property name="dataSourceBean" value = "simpleDataSource"
/>
              </bean>
            </property>
        </bean>
      </list>
    </property>
</bean>

%HIVE_JDBC_DRIVER% you can find here:

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.4/bk_data-access/content/hive-jdbc-odbc-drivers.html

For more information read next:

https://apacheignite.readme.io/docs/3rd-party-store

Best Regards,
Andrei



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/