Add Phoenix(UPSERT) support for TableOutput.

[lin-yao]

Update pentaho-kettle/engine/src/main/java/org/pentaho/di/trans/steps/tableoutput/TableOutput.java.

[wingman-pentaho]

Hello, This is an automated comment from our build system. Since this pull request originated from a user not in the Pentaho organization, we will not proceed with automatic validation of the pull request. However, rest assured that it will be reviewed manually as soon as we get the chance. Thanks for your contribution!

[buildguy]

:gear: Build finished in 19m 14s with command:

mvn clean verify -B -e -f pom.xml -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -U -Dmaven-surefire-plugin.argLine=-XX:MaxRAMPercentage=90.0 -Dmaven-failsafe-plugin.argLine=-XX:MaxRAMPercentage=90.0 -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3532	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 19m 1s with command:

mvn clean verify -B -e -f pom.xml -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -U -Dmaven-surefire-plugin.argLine=-XX:MaxRAMPercentage=90.0 -Dmaven-failsafe-plugin.argLine=-XX:MaxRAMPercentage=90.0 -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3532	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 19m 5s with command:

mvn clean verify -B -e -f pom.xml -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -U -Dmaven-surefire-plugin.argLine=-XX:MaxRAMPercentage=90.0 -Dmaven-failsafe-plugin.argLine=-XX:MaxRAMPercentage=90.0 -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3532	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 21m 2s with command:

mvn clean verify -B -e -f pom.xml -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -U -Dmaven-surefire-plugin.argLine=-XX:MaxRAMPercentage=90.0 -Dmaven-failsafe-plugin.argLine=-XX:MaxRAMPercentage=90.0 -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3530	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 22m 4s with command:

mvn clean verify -B -e -f pom.xml -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -U -Dmaven-surefire-plugin.argLine=-XX:MaxRAMPercentage=90.0 -Dmaven-failsafe-plugin.argLine=-XX:MaxRAMPercentage=90.0 -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3530	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 24m 11s with command:

mvn clean verify -f pom.xml -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -U -Dmaven-surefire-plugin.argLine=-XX:MaxRAMPercentage=90.0 -Dmaven-failsafe-plugin.argLine=-XX:MaxRAMPercentage=90.0 -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 16 test(s) failed:

• org.pentaho.di.pan.PanCommandExecutorTest.testFilesystemBase64Zip

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.pan.PanCommandExecutorTest.testExecuteWithInvalidRepository

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.pan.PanCommandExecutorTest.testMetastoreFromRepoAddedIn

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.pan.PanCommandExecutorTest.testMetastoreFromFilesystemAddedIn

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.trans.StepWithMappingMetaTest.loadMappingMeta

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.trans.StepWithMappingMetaTest.loadMappingMetaTest

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.trans.StepWithMappingMetaTest.testFileNameAsVariable

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.trans.TransMetaTest.testSetInternalEntryCurrentDirectoryWithRepository

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.trans.TransMetaTest.testLoadXml

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.trans.TransMetaTest.testTransWithOneStepIsConsideredUsed

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.www.ExecuteJobServletTest.testExecuteJobServletTest

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.www.ExecuteJobServletTest.testExecuteJobServletTestCantFindDirectory

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.www.ExecuteJobServletTest.testExecuteJobServletTestJobNotFoundInDirectory

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.www.ExecuteJobServletTest.testExecuteJobServletTestCantFindRepository

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.www.ExecuteJobServletTest.testExecuteJobServletTestWithUnauthorizedUser

    javassist.CannotCompileException: by java.util.zip.ZipException: invalid distance too far back

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3539	16	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 15m 42s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
2356	1	6

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 15m 32s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
2356	1	6

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 15m 55s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
2356	1	6

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 15m 34s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
2355	1	6

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 15m 39s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
2357	1	6

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 15m 27s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd -Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
2357	1	6

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 21m 26s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 2 test(s) failed:

• org.pentaho.di.trans.step.mqtt.MQTTStreamSourceTest.testMqttStreamSingleTopic

    ${result.errorDetails}

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3544	2	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 21m 30s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3557	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 22m 52s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3557	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 22m 53s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3557	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 3m with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -P !assemblies -pl engine

:exclamation: No tests found!

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 22m 4s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3557	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 23m 20s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3557	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 23m 18s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -P !assemblies -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3565	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 24m 23s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3571	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 23m 27s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3572	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 22m 59s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3572	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 22m 50s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3577	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 24m 26s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3579	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 24m 18s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3579	1	7

Details

:information_source: This is an automatic message

[buildguy]

:gear: Build finished in 22m 23s with command:

mvn clean verify -B -e -Daether.connector.resumeDownloads=false -amd \
-Daudit -pl engine

:warning: Failed Tests

---

:cloud_with_lightning_and_rain: 1 test(s) failed:

• org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable

    ${result.errorDetails}

---

Total	Failed	Skipped
3579	1	7

Details

:information_source: This is an automatic message

[buildguy]

:warning: Build finished in 24m 22s

Build command:

mvn clean verify -B -e -Daudit -amd -pl engine

---

:no_entry: Failed Tests

:cloud_with_lightning_and_rain: 1 test(s) failed:

org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable (click to expand)

${result.errorDetails}

Tests run: 3579, Failures: 1, Skipped: 7    Test Results

---

:information_source: This is an automatic message

[buildguy]

:warning: Build finished in 23m 6s

Build command:

mvn clean verify -B -e -Daudit -amd -pl engine

---

:no_entry: Failed Tests

:cloud_with_lightning_and_rain: 1 test(s) failed:

org.pentaho.di.trans.steps.tableoutput.TableOutputTest.testWriteToTable (click to expand)

${result.errorDetails}

Tests run: 3588, Failures: 1, Skipped: 7    Test Results

---

:information_source: This is an automatic message