[jira] [Updated] (TRAFODION-1632) Hive scan on wide tables with several string type columns causes SIGSEGV

["Jian Jin (JIRA)" <ji...@apache.org>]

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