You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "liu ming (JIRA)" <ji...@apache.org> on 2016/05/18 14:28:13 UTC
[jira] [Commented] (TRAFODION-1632) Hive scan on wide tables with
several string type columns causes SIGSEGV
[ https://issues.apache.org/jira/browse/TRAFODION-1632?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15289052#comment-15289052 ]
liu ming commented on TRAFODION-1632:
-------------------------------------
create table Input_10_TestClientData
(
sourcehistoryuid bigint
,importdate timestamp
,filedate timestamp
,exclusionindicator tinyint
,DataCategory STRING
,TransactionReferenceNumber STRING
,ReportStatus STRING
,ReporterIDType STRING
,ReporterID STRING
,SubmitterIDType STRING
,SubmitterID STRING
,Buyer_ID_Type STRING
,Buyer_ID STRING
,BuyerCountryofBranch STRING
,BuyerFirstName STRING
,BuyerSurname STRING
,BuyerDOB STRING
,BuyerCountryofResidence STRING
,BuyerPostCode STRING
,BuyerDecisionMakerIDType STRING
,BuyerDecisionMakerID STRING
,BuyerDecisionMakerFirstName STRING
,BuyerDecisionMakerSurname STRING
,BuyerDecisionMakerDOB STRING
,BuyerDecisionMakerCountryofResidence STRING
,BuyerDecisionMakerPostCode STRING
,SellerIDType STRING
,SellerID STRING
,SellerCountryofBranch STRING
,SellerFirstName STRING
,SellerSurname STRING
,SellerDOB STRING
,SellerCountryofResidence STRING
,SellerPostCode STRING
,SellerDecisionMakerIDType STRING
,SellerDecisionMakerID STRING
,SellerDecisionMakerFirstName STRING
,SellerDecisionMakerSurname STRING
,SellerDecisionMakerDOB STRING
,SellerDecisionMakerCountryofResidence STRING
,SellerDecisionMakerPostCode STRING
,OrderTransmissionIndicator STRING
,BuyerTransmitterIDType STRING
,BuyerTransmitterID STRING
,SellerTransmitterIDType STRING
,SellerTransmitterID STRING
,TradingDate STRING
,TradingTime STRING
,TradingCapacity STRING
,Quantity STRING
,QuantityNotation STRING
,Price STRING
,PriceNotation STRING
,Currency1 STRING
,Currency2 STRING
,PriceMultiplier STRING
,Consideration STRING
,Venue STRING
,ExecutingCountryofBranch STRING
,InstrumentIDType STRING
,InstrumentID STRING
,InstrumentClassificationType STRING
,InstrumentClassification STRING
,UnderlyingInstrumentIDType STRING
,UnderlyingInstrumentID STRING
,PutCall STRING
,StrikePrice STRING
,OptionStyle STRING
,MaturityDate STRING
,ResultofExercise STRING
,DeliveryType STRING
,UpFrontPayment STRING
,UpFrontPaymentCurrency STRING
,ContractModificationType STRING
,InvestmentTraderIDType STRING
,InvestmentTraderID STRING
,InvestmentTraderCountryofBranch STRING
,ExecutionTraderIDType STRING
,ExecutionTraderID STRING
,ExecutionTraderCountryofBranch STRING
,InvestmentAlgorithmID STRING
,ExecutionAlgorithmID STRING
,WaiverIndicator STRING
,ShortSellingIndicator STRING
,OTCPostTradeIndicator STRING
,CommodityDerivativeIndicator STRING
,ReloadSourceHistoryUID STRING
) ;
will pass Hive syntax checking
> Hive scan on wide tables with several string type columns causes SIGSEGV
> -------------------------------------------------------------------------
>
> Key: TRAFODION-1632
> URL: https://issues.apache.org/jira/browse/TRAFODION-1632
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Affects Versions: 1.3-incubating
> Reporter: Suresh Subbiah
> Attachments: hs_err_pid54160.log
>
>
> This query caused a process abort.
> select * from hive.hive."Input_10_TestClientData_1" limit 10;
> Table has 88 columns and 100K rows
> Hive DDL is
> create table "Input_10_TestClientData" (
> ,"sourcehistoryuid" bigint
> ,"importdate" timestamp
> ,"filedate" timestamp
> ,"exclusionindicator" tinyint
> ,"Data Category" STRING
> ,"Transaction Reference Number" STRING
> ,"Report Status" STRING
> ,"Reporter ID Type" STRING
> ,"Reporter ID" STRING
> ,"Submitter ID Type" STRING
> ,"Submitter ID" STRING
> ,"Buyer ID Type" STRING
> ,"Buyer ID" STRING
> ,"Buyer Country of Branch" STRING
> ,"Buyer First Name" STRING
> ,"Buyer Surname" STRING
> ,"Buyer DOB" STRING
> ,"Buyer Country of Residence" STRING
> ,"Buyer Post Code" STRING
> ,"Buyer Decision Maker ID Type" STRING
> ,"Buyer Decision Maker ID" STRING
> ,"Buyer Decision Maker First Name" STRING
> ,"Buyer Decision Maker Surname" STRING
> ,"Buyer Decision Maker DOB" STRING
> ,"Buyer Decision Maker Country of Residence" STRING
> ,"Buyer Decision Maker Post Code" STRING
> ,"Seller ID Type" STRING
> ,"Seller ID" STRING
> ,"Seller Country of Branch" STRING
> ,"Seller First Name" STRING
> ,"Seller Surname" STRING
> ,"Seller DOB" STRING
> ,"Seller Country of Residence" STRING
> ,"Seller Post Code" STRING
> ,"Seller Decision Maker ID Type" STRING
> ,"Seller Decision Maker ID" STRING
> ,"Seller Decision Maker First Name" STRING
> ,"Seller Decision Maker Surname" STRING
> ,"Seller Decision Maker DOB" STRING
> ,"Seller Decision Maker Country of Residence" STRING
> ,"Seller Decision Maker Post Code" STRING
> ,"Order Transmission Indicator" STRING
> ,"Buyer Transmitter ID Type" STRING
> ,"Buyer Transmitter ID" STRING
> ,"Seller Transmitter ID Type" STRING
> ,"Seller Transmitter ID" STRING
> ,"Trading Date" STRING
> ,"Trading Time" STRING
> ,"Trading Capacity" STRING
> ,"Quantity" STRING
> ,"Quantity Notation" STRING
> ,"Price" STRING
> ,"Price Notation" STRING
> ,"Currency 1" STRING
> ,"Currency 2" STRING
> ,"Price Multiplier" STRING
> ,"Consideration" STRING
> ,"Venue" STRING
> ,"Executing Country of Branch" STRING
> ,"Instrument ID Type" STRING
> ,"Instrument ID" STRING
> ,"Instrument Classification Type" STRING
> ,"Instrument Classification" STRING
> ,"Underlying Instrument ID Type" STRING
> ,"Underlying Instrument ID" STRING
> ,"Put/Call" STRING
> ,"Strike Price" STRING
> ,"Option Style" STRING
> ,"Maturity Date" STRING
> ,"Result of Exercise" STRING
> ,"Delivery Type" STRING
> ,"Up-Front Payment" STRING
> ,"Up-Front Payment Currency" STRING
> ,"Contract Modification Type" STRING
> ,"Investment Trader ID Type" STRING
> ,"Investment Trader ID" STRING
> ,"Investment Trader Country of Branch" STRING
> ,"Execution Trader ID Type" STRING
> ,"Execution Trader ID" STRING
> ,"Execution Trader Country of Branch" STRING
> ,"Investment Algorithm ID" STRING
> ,"Execution Algorithm ID" STRING
> ,"Waiver Indicator" STRING
> ,"Short Selling Indicator" STRING
> ,"OTC Post Trade Indicator" STRING
> ,"Commodity Derivative Indicator" STRING
> ,"Reload SourceHistoryUID" STRING
> ) ;
> We do not have data. Fake data willhave to be used if necessary.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)