hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-20833) package.jdo needs to be updated to conform with HIVE-20221 changes
Date Tue, 30 Oct 2018 08:32:00 GMT

    [ 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)

Mime
View raw message