Mailing-List: contact dev-help@apex.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@apex.apache.org
MIME-Version: 1.0
From: Hitesh Kapoor <hitesh@datatorrent.com>
Date: Fri, 13 Jan 2017 15:57:18 +0530
Message-ID: <CA+LJDcVrzN_=tgpcQ5Xrs_J7=0S5=wgHjw+zeNaBifLJQ2o6tg@mail.gmail.com>
Subject: APEXMALHAR-2382 User needs to create dt_meta table while using JdbcPOJOInsertOutputOperator
To: dev@apex.apache.org
Content-Type: multipart/alternative; boundary=94eb2c12f8b4446f7b0545f747d0
archived-at: Fri, 13 Jan 2017 10:27:23 -0000

--94eb2c12f8b4446f7b0545f747d0
Content-Type: text/plain; charset=UTF-8

Hi All,

Currently to use JdbcPOJOInsertOutputOperator, user needs to create
"dt_meta" table to enforce
exactly-once processing semantic. If the user fails to create this table
before launching the application an exception is thrown.
To handle this scenario we can automate the process of creating this table,
assuming the user has the appropriate privileges. The problem with this
approach is that it may not be a very good idea to modify user's database
automatically , also if the user doesn't has the appropriate privileges it
will eventually throw an exception (however a different exception).
So I need your opinion if we should automate the creation of this internal
table (if it doesn't exists) or continue with the existing behaviour or
anything else.

Regards,
Hitesh

--94eb2c12f8b4446f7b0545f747d0--