[
https://issues.apache.org/jira/browse/HIVE-20833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16668335#comment-16668335
]
Hive QA commented on HIVE-20833:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12946140/HIVE-20833.1.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 185 failed/errored test(s), 15513 tests
executed
*Failed tests:*
{noformat}
TestMiniDruidCliDriver - did not produce a TEST-*.xml file (likely timed out)
(batchId=195)
[druidmini_dynamic_partition.q,druidmini_test_ts.q,druidmini_expressions.q,druidmini_test_alter.q,druidmini_test_insert.q]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[alter_partition_change_col]
(batchId=27)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[infer_bucket_sort_reducers_power_two]
(batchId=14)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cbo_limit]
(batchId=182)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryDBPattern
(batchId=221)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryDisabledByDefault
(batchId=221)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryEnabledBothTableTypes
(batchId=221)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryNonDefaultCatalog
(batchId=221)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoverySkipInvalidPath
(batchId=221)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryTablePattern
(batchId=221)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionDiscoveryTransactionalTable
(batchId=221)
org.apache.hadoop.hive.metastore.TestPartitionManagement.testPartitionRetention
(batchId=221)
org.apache.hadoop.hive.ql.TestTxnAddPartition.addPartition (batchId=320)
org.apache.hadoop.hive.ql.TestTxnAddPartition.addPartitionBucketed (batchId=320)
org.apache.hadoop.hive.ql.TestTxnAddPartition.addPartitionMM (batchId=320)
org.apache.hadoop.hive.ql.TestTxnAddPartition.addPartitionMMVectorized
(batchId=320)
org.apache.hadoop.hive.ql.TestTxnAddPartition.addPartitionRename (batchId=320)
org.apache.hadoop.hive.ql.TestTxnAddPartition.addPartitionVectorized
(batchId=320)
org.apache.hadoop.hive.ql.TestTxnCommands.exchangePartition (batchId=323)
org.apache.hadoop.hive.ql.TestTxnCommands.testMergeCardinalityViolation
(batchId=323)
org.apache.hadoop.hive.ql.TestTxnCommands2.testBucketizedInputFormat
(batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2.testCleanerForTxnToWriteId
(batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2.testDynamicPartitionsMerge
(batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2.testDynamicPartitionsMerge2
(batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2.testInsertOverwriteWithSelfJoin
(batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2.testMerge (batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2.testMerge2 (batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2.testMerge3 (batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2.testMergeWithPredicate (batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2.testMultiInsert (batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2.testMultiInsertStatement
(batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2.updateDeletePartitioned (batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testBucketizedInputFormat
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testCleanerForTxnToWriteId
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testDynamicPartitionsMerge
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testDynamicPartitionsMerge2
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testInsertOverwriteWithSelfJoin
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testMerge
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testMerge2
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testMerge3
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testMergeWithPredicate
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testMultiInsert
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.testMultiInsertStatement
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands2WithSplitUpdateAndVectorization.updateDeletePartitioned
(batchId=319)
org.apache.hadoop.hive.ql.TestTxnCommands3.testSdpoBucketed (batchId=320)
org.apache.hadoop.hive.ql.TestTxnCommandsForMmTable.testInsertOverwriteForPartitionedMmTable
(batchId=283)
org.apache.hadoop.hive.ql.TestTxnCommandsForMmTable.testInsertOverwriteWithDynamicPartition
(batchId=283)
org.apache.hadoop.hive.ql.TestTxnCommandsForOrcMmTable.testInsertOverwriteForPartitionedMmTable
(batchId=305)
org.apache.hadoop.hive.ql.TestTxnCommandsForOrcMmTable.testInsertOverwriteWithDynamicPartition
(batchId=305)
org.apache.hadoop.hive.ql.TestTxnCommandsWithSplitUpdateAndVectorization.exchangePartition
(batchId=307)
org.apache.hadoop.hive.ql.TestTxnCommandsWithSplitUpdateAndVectorization.testMergeCardinalityViolation
(batchId=307)
org.apache.hadoop.hive.ql.TestTxnConcatenate.testConcatenatePart (batchId=292)
org.apache.hadoop.hive.ql.TestTxnExIm.testExportPart (batchId=305)
org.apache.hadoop.hive.ql.TestTxnExIm.testExportPartPartial (batchId=305)
org.apache.hadoop.hive.ql.TestTxnExIm.testExportPartPartial2 (batchId=305)
org.apache.hadoop.hive.ql.TestTxnExIm.testExportPartPartial3 (batchId=305)
org.apache.hadoop.hive.ql.TestTxnExIm.testImportPartitioned (batchId=305)
org.apache.hadoop.hive.ql.TestTxnExIm.testImportPartitionedCreate (batchId=305)
org.apache.hadoop.hive.ql.TestTxnExIm.testImportPartitionedCreate2 (batchId=305)
org.apache.hadoop.hive.ql.TestTxnLoadData.loadDataPartitioned (batchId=283)
org.apache.hadoop.hive.ql.TestTxnNoBuckets.testCompactStatsGather (batchId=307)
org.apache.hadoop.hive.ql.TestTxnNoBuckets.testNoBucketsDP (batchId=307)
org.apache.hadoop.hive.ql.TestTxnNoBucketsVectorized.testCompactStatsGather
(batchId=307)
org.apache.hadoop.hive.ql.TestTxnNoBucketsVectorized.testNoBucketsDP
(batchId=307)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.checkExpectedLocks2
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testCompletedTxnComponents
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testDynamicPartitionInsert
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testFairness2 (batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testMerge3Way01
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testMerge3Way02
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testMergePartitioned01
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testMergePartitioned02
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testMetastoreTablesCleanup
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testMultiInsert
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testWriteSetTracking10
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testWriteSetTracking11
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testWriteSetTracking3
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testWriteSetTracking5
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testWriteSetTracking7
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testWriteSetTracking8
(batchId=322)
org.apache.hadoop.hive.ql.lockmgr.TestDbTxnManager2.testWriteSetTracking9
(batchId=322)
org.apache.hadoop.hive.ql.stats.TestStatsUpdaterThread.testAllPartitions
(batchId=293)
org.apache.hadoop.hive.ql.stats.TestStatsUpdaterThread.testParallelOps
(batchId=293)
org.apache.hadoop.hive.ql.stats.TestStatsUpdaterThread.testPartitionSubset
(batchId=293)
org.apache.hadoop.hive.ql.stats.TestStatsUpdaterThread.testPartitionsWithDifferentColsAll
(batchId=293)
org.apache.hadoop.hive.ql.stats.TestStatsUpdaterThread.testPartitionsWithDifferentColsExistingOnly
(batchId=293)
org.apache.hadoop.hive.ql.stats.TestStatsUpdaterThread.testQueueingWithThreads
(batchId=293)
org.apache.hadoop.hive.ql.stats.TestStatsUpdaterThread.testTxnPartitions
(batchId=293)
org.apache.hadoop.hive.ql.txn.compactor.TestCleanerWithReplication.cleanupAfterMajorPartitionCompaction
(batchId=244)
org.apache.hadoop.hive.ql.txn.compactor.TestCleanerWithReplication.cleanupAfterMinorPartitionCompaction
(batchId=244)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.dynamicPartitioningDelete[0]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.dynamicPartitioningDelete[1]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.dynamicPartitioningInsert[0]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.dynamicPartitioningInsert[1]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.dynamicPartitioningUpdate[0]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.dynamicPartitioningUpdate[1]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.mmTablePartitioned[0]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.mmTablePartitioned[1]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.schemaEvolutionAddColDynamicPartitioningInsert[0]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.schemaEvolutionAddColDynamicPartitioningInsert[1]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.schemaEvolutionAddColDynamicPartitioningUpdate[0]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.schemaEvolutionAddColDynamicPartitioningUpdate[1]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.testStatsAfterCompactionPartTbl[0]
(batchId=243)
org.apache.hadoop.hive.ql.txn.compactor.TestCompactor.testStatsAfterCompactionPartTbl[1]
(batchId=243)
org.apache.hadoop.hive.ql.util.TestUpgradeTool.testPostUpgrade (batchId=283)
org.apache.hive.hcatalog.streaming.TestStreaming.testAddPartition (batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testBucketing (batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testBucketingWhereBucketColIsNotFirstCol
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testConcurrentTransactionBatchCommits
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testCreatePartition
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testEndpointConnection
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testErrorHandling (batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testFileDump (batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testFileDumpCorruptDataFiles
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testFileDumpCorruptSideFiles
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testHeartbeat (batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testInterleavedTransactionBatchCommits
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testMultipleTransactionBatchCommits
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testNoBuckets (batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testRemainingTransactions
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testStreamBucketingMatchesRegularBucketing
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testTableValidation
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testTimeOutReaper (batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchAbort
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchAbortAndCommit
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_Delimited
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_DelimitedUGI
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_Json
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_Regex
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchCommit_RegexUGI
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchEmptyAbort
(batchId=217)
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchEmptyCommit
(batchId=217)
org.apache.hive.hcatalog.streaming.mutate.TestMutations.testMulti (batchId=217)
org.apache.hive.hcatalog.streaming.mutate.TestMutations.testTransactionBatchAbort
(batchId=217)
org.apache.hive.hcatalog.streaming.mutate.TestMutations.testTransactionBatchCommitPartitioned
(batchId=217)
org.apache.hive.hcatalog.streaming.mutate.TestMutations.testTransactionBatchEmptyAbortPartitioned
(batchId=217)
org.apache.hive.hcatalog.streaming.mutate.TestMutations.testTransactionBatchEmptyCommitPartitioned
(batchId=217)
org.apache.hive.hcatalog.streaming.mutate.TestMutations.testUpdatesAndDeletes
(batchId=217)
org.apache.hive.streaming.TestStreaming.testAddDynamicPartitionWithWriteId
(batchId=330)
org.apache.hive.streaming.TestStreaming.testAddPartition (batchId=330)
org.apache.hive.streaming.TestStreaming.testAddPartitionWithWriteId
(batchId=330)
org.apache.hive.streaming.TestStreaming.testAllTypesDelimitedWriter
(batchId=330)
org.apache.hive.streaming.TestStreaming.testAllTypesDelimitedWriterInputStream
(batchId=330)
org.apache.hive.streaming.TestStreaming.testAutoRollTransactionBatch
(batchId=330)
org.apache.hive.streaming.TestStreaming.testBucketing (batchId=330)
org.apache.hive.streaming.TestStreaming.testBucketingWhereBucketColIsNotFirstCol
(batchId=330)
org.apache.hive.streaming.TestStreaming.testCommitWithKeyValue (batchId=330)
org.apache.hive.streaming.TestStreaming.testConcurrentTransactionBatchCommits
(batchId=330)
org.apache.hive.streaming.TestStreaming.testConnectionWithWriteId (batchId=330)
org.apache.hive.streaming.TestStreaming.testEndpointConnection (batchId=330)
org.apache.hive.streaming.TestStreaming.testErrorHandling (batchId=330)
org.apache.hive.streaming.TestStreaming.testFileDump (batchId=330)
org.apache.hive.streaming.TestStreaming.testFileDumpCorruptDataFiles
(batchId=330)
org.apache.hive.streaming.TestStreaming.testFileDumpCorruptSideFiles
(batchId=330)
org.apache.hive.streaming.TestStreaming.testFileDumpDeltaFilesWithStreamingOptimizations
(batchId=330)
org.apache.hive.streaming.TestStreaming.testFileDumpDeltaFilesWithoutStreamingOptimizations
(batchId=330)
org.apache.hive.streaming.TestStreaming.testGetDeltaPath (batchId=330)
org.apache.hive.streaming.TestStreaming.testHeartbeat (batchId=330)
org.apache.hive.streaming.TestStreaming.testInterleavedTransactionBatchCommits
(batchId=330)
org.apache.hive.streaming.TestStreaming.testJsonInputStream (batchId=330)
org.apache.hive.streaming.TestStreaming.testMultipleTransactionBatchCommits
(batchId=330)
org.apache.hive.streaming.TestStreaming.testNoBuckets (batchId=330)
org.apache.hive.streaming.TestStreaming.testRegexInputStream (batchId=330)
org.apache.hive.streaming.TestStreaming.testRemainingTransactions (batchId=330)
org.apache.hive.streaming.TestStreaming.testStreamBucketingMatchesRegularBucketing
(batchId=330)
org.apache.hive.streaming.TestStreaming.testTableValidation (batchId=330)
org.apache.hive.streaming.TestStreaming.testTimeOutReaper (batchId=330)
org.apache.hive.streaming.TestStreaming.testTransactionBatchAbort (batchId=330)
org.apache.hive.streaming.TestStreaming.testTransactionBatchAbortAndCommit
(batchId=330)
org.apache.hive.streaming.TestStreaming.testTransactionBatchCommitDelimited
(batchId=330)
org.apache.hive.streaming.TestStreaming.testTransactionBatchCommitJson
(batchId=330)
org.apache.hive.streaming.TestStreaming.testTransactionBatchCommitRegex
(batchId=330)
org.apache.hive.streaming.TestStreaming.testTransactionBatchEmptyAbort
(batchId=330)
org.apache.hive.streaming.TestStreaming.testTransactionBatchEmptyCommit
(batchId=330)
org.apache.hive.streaming.TestStreamingDynamicPartitioning.testDPStreamBucketingMatchesRegularBucketing
(batchId=330)
org.apache.hive.streaming.TestStreamingDynamicPartitioning.testDPTwoLevel
(batchId=330)
org.apache.hive.streaming.TestStreamingDynamicPartitioning.testDPTwoLevelMissingPartitionValues
(batchId=330)
org.apache.hive.streaming.TestStreamingDynamicPartitioning.testDPTwoLevelNonStringPartitionColumns
(batchId=330)
org.apache.hive.streaming.TestStreamingDynamicPartitioning.testDynamicPartitioning
(batchId=330)
org.apache.hive.streaming.TestStreamingDynamicPartitioning.testJsonInputStreamDP
(batchId=330)
org.apache.hive.streaming.TestStreamingDynamicPartitioning.testRegexInputStreamDP
(batchId=330)
org.apache.hive.streaming.TestStreamingDynamicPartitioning.testTableValidation
(batchId=330)
org.apache.hive.streaming.TestStreamingDynamicPartitioning.testWriteAfterAbort
(batchId=330)
org.apache.hive.streaming.TestStreamingDynamicPartitioning.testWriteAfterClose
(batchId=330)
org.apache.hive.streaming.TestStreamingDynamicPartitioning.testWriteBeforeBegin
(batchId=330)
{noformat}
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/14689/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/14689/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-14689/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.YetusPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 185 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12946140 - PreCommit-HIVE-Build
> package.jdo needs to be updated to conform with HIVE-20221 changes
> ------------------------------------------------------------------
>
> Key: HIVE-20833
> URL: https://issues.apache.org/jira/browse/HIVE-20833
> Project: Hive
> Issue Type: Bug
> Affects Versions: 4.0.0
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Priority: Major
> Attachments: HIVE-20833.1.patch
>
>
> Following test if run with TestMiniLlapLocalCliDriver will fail:
> {code:sql}
> CREATE TABLE `alterPartTbl`(
> `po_header_id` bigint,
> `vendor_num` string,
> `requester_name` string,
> `approver_name` string,
> `buyer_name` string,
> `preparer_name` string,
> `po_requisition_number` string,
> `po_requisition_id` bigint,
> `po_requisition_desc` string,
> `rate_type` string,
> `rate_date` date,
> `rate` double,
> `blanket_total_amount` double,
> `authorization_status` string,
> `revision_num` bigint,
> `revised_date` date,
> `approved_flag` string,
> `approved_date` timestamp,
> `amount_limit` double,
> `note_to_authorizer` string,
> `note_to_vendor` string,
> `note_to_receiver` string,
> `vendor_order_num` string,
> `comments` string,
> `acceptance_required_flag` string,
> `acceptance_due_date` date,
> `closed_date` timestamp,
> `user_hold_flag` string,
> `approval_required_flag` string,
> `cancel_flag` string,
> `firm_status_lookup_code` string,
> `firm_date` date,
> `frozen_flag` string,
> `closed_code` string,
> `org_id` bigint,
> `reference_num` string,
> `wf_item_type` string,
> `wf_item_key` string,
> `submit_date` date,
> `sap_company_code` string,
> `sap_fiscal_year` bigint,
> `po_number` string,
> `sap_line_item` bigint,
> `closed_status_flag` string,
> `balancing_segment` string,
> `cost_center_segment` string,
> `base_amount_limit` double,
> `base_blanket_total_amount` double,
> `base_open_amount` double,
> `base_ordered_amount` double,
> `cancel_date` timestamp,
> `cbc_accounting_date` date,
> `change_requested_by` string,
> `change_summary` string,
> `confirming_order_flag` string,
> `document_creation_method` string,
> `edi_processed_flag` string,
> `edi_processed_status` string,
> `enabled_flag` string,
> `encumbrance_required_flag` string,
> `end_date` date,
> `end_date_active` date,
> `from_header_id` bigint,
> `from_type_lookup_code` string,
> `global_agreement_flag` string,
> `government_context` string,
> `interface_source_code` string,
> `ledger_currency_code` string,
> `open_amount` double,
> `ordered_amount` double,
> `pay_on_code` string,
> `payment_term_name` string,
> `pending_signature_flag` string,
> `po_revision_num` double,
> `preparer_id` bigint,
> `price_update_tolerance` double,
> `print_count` double,
> `printed_date` date,
> `reply_date` date,
> `reply_method_lookup_code` string,
> `rfq_close_date` date,
> `segment2` string,
> `segment3` string,
> `segment4` string,
> `segment5` string,
> `shipping_control` string,
> `start_date` date,
> `start_date_active` date,
> `summary_flag` string,
> `supply_agreement_flag` string,
> `usd_amount_limit` double,
> `usd_blanket_total_amount` double,
> `usd_exchange_rate` double,
> `usd_open_amount` double,
> `usd_order_amount` double,
> `ussgl_transaction_code` string,
> `xml_flag` string,
> `purchasing_organization_id` bigint,
> `purchasing_group_code` string,
> `last_updated_by_name` string,
> `created_by_name` string,
> `incoterms_1` string,
> `incoterms_2` string,
> `ame_approval_id` double,
> `ame_transaction_type` string,
> `auto_sourcing_flag` string,
> `cat_admin_auth_enabled_flag` string,
> `clm_document_number` string,
> `comm_rev_num` double,
> `consigned_consumption_flag` string,
> `consume_req_demand_flag` string,
> `conterms_articles_upd_date` timestamp,
> `conterms_deliv_upd_date` timestamp,
> `conterms_exist_flag` string,
> `cpa_reference` double,
> `created_language` string,
> `email_address` string,
> `enable_all_sites` string,
> `fax` string,
> `lock_owner_role` string,
> `lock_owner_user_id` double,
> `min_release_amount` double,
> `mrc_rate` string,
> `mrc_rate_date` string,
> `mrc_rate_type` string,
> `otm_recovery_flag` string,
> `otm_status_code` string,
> `pay_when_paid` string,
> `pcard_id` bigint,
> `program_update_date` timestamp,
> `quotation_class_code` string,
> `quote_type_lookup_code` string,
> `quote_vendor_quote_number` string,
> `quote_warning_delay` double,
> `quote_warning_delay_unit` string,
> `retro_price_apply_updates_flag` string,
> `retro_price_comm_updates_flag` string,
> `style_id` double,
> `supplier_auth_enabled_flag` string,
> `supplier_notif_method` string,
> `tax_attribute_update_code` string,
> `update_sourcing_rules_flag` string,
> `xml_change_send_date` timestamp,
> `xml_send_date` timestamp,
> `primary_po_distribution_id` bigint,
> `primary_dist_code_combination_id` bigint,
> `group_requisitions` string,
> `group_requisition_lines` string,
> `use_need_by_date` string,
> `use_ship_to` string,
> `document_status` string,
> `prc_bu_id` bigint,
> `req_bu_id` bigint,
> `default_taxation_country` string,
> `tax_document_subtype` string,
> `del_flag` int)
> PARTITIONED BY (
> `source_system_name` string);
> alter table alterPartTbl add partition(source_system_name='CCL');
> drop table alterPartTbl;
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
