[
https://issues.apache.org/jira/browse/TRAFODION-1632?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jian Jin updated TRAFODION-1632:
--------------------------------
Assignee: Howard Qin
> 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
> Assignee: Howard Qin
> 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)
