About Matt Jacobs

Robert Justice · ‎03-12-2019

As upsert is not SQL-92 syntax, the Impala JDBC driver does not currently support it. However, we are currently testing a newer version of JDBC driver and hope to support upsert in the near future. For the time being, please break these statements into a combination of insert and update statements.

brianwhu · ‎04-13-2017

Hi Matt, It seems we are going down this path for now. It is close enough to what we have in Vertica, which does grow new partitions automatically though. Thanks, Brian

Brycert1 · ‎07-25-2016

Thanks MJ, will definitely try that and let you know.

Matt Jacobs · ‎06-30-2016

We're working on it and it should be in the next release, but unfortunately we're not aware of a good way to simulate the same results.

nasmart.me · ‎07-01-2015

Thanks for the response. I have been meaning to come back and add a comment here. I found the root of the problem as well as the solution here: http://community.cloudera.com/t5/Interactive-Short-cycle-SQL/kerberos-authentication-failure-GSSAPI-Failure-gss-accept-sec/td-p/23333

Matt Jacobs · ‎04-23-2015

mapreduce.jobhistory.webapp.address in CM needs to be set to the port the service should listen on. If you'd like the port to be open on multiple interfaces, you can use the 'Bind JobHistory Server to Wildcard Address' setting.

Online	Offline
Last Visited	‎08-09-2017 02:23 PM

Member Since	‎12-19-2013 10:12 AM
Last Visited	‎08-09-2017 02:23 PM
Posts	16
Kudos received	1

Cloudera Community

Re: Impala/Kudu non-covering range partition to su...

Re: Forward filling and back filling from adjacent...

Re: Setting hostname:port for WEB UI address retur...

Re: impala jdbc not support UPSERT preparestatemen...

Re: Impala/Kudu non-covering range partition to su...

Re: Impala Kudu distribute by hash() not working

Re: Forward filling and back filling from adjacent...

Re: Impala kerberos error

Re: Setting hostname:port for WEB UI address retur...