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

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

Suresh Subbiah created TRAFODION-1632:
-----------------------------------------

             Summary: 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


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)