topic I am using phoenix as dataSource for data models, while update ,statement which executes is like 'update table SET =? where ID= ?' , instead i want it to execute Upsert statement over phoenix to query Hbase. Please Help!! in Alfresco Forum

I am using phoenix as dataSource for data models, while update ,statement which executes is like 'update table SET =? where ID= ?' , instead i want it to execute Upsert statement over phoenix to query Hbase. Please Help!!

dharamjeet — Sat, 14 Jan 2017 08:08:07 GMT

I am using phoenix as dataSource for data models in alfresco activiti, while update ,statement which executes is like 'update table SET =? where ID= ?' , instead i want it to execute Upsert statement over phoenix to query Hbase. Also HBase uses column family with column name, If I map my variable wi

Re: I am using phoenix as dataSource for data models, while update ,statement which executes is like 'update table SET =? where ID= ?' , instead i want it to execute Upsert statement over phoenix to query Hbase. Please Help!!

gdharley — Mon, 16 Jan 2017 23:12:45 GMT

Not sure I understand what you are trying to do.

Can you provide a scenario and unit test?

Thanks,

Greg

‌

Re: I am using phoenix as dataSource for data models, while update ,statement which executes is like 'update table SET =? where ID= ?' , instead i want it to execute Upsert statement over phoenix to query Hbase. Please Help!!

dharamjeet — Fri, 20 Jan 2017 08:07:35 GMT

https://community.alfresco.com/community/bpm/blog/2016/11/17/activiti-enterprise-developer-series-custom-data-models

This helped me.

what I wanted to do is to map my data model with my database, I defined the dataSource for my data model ,but It as internally creating queries internally and I wanted to execute my custom query since I had to execute an upsert statement. so what I did is defined custom model and implemented AlfrescoCustomDataModel Service.

Re: I am using phoenix as dataSource for data models, while update ,statement which executes is like 'update table SET =? where ID= ?' , instead i want it to execute Upsert statement over phoenix to query Hbase. Please Help!!

gdharley — Fri, 20 Jan 2017 16:34:40 GMT

Glad to hear it, the developer series blog posts are very good and certainly worth following.

Regards,

Greg

‌