Kylo remembering decimal parameters when data type changed back to String.

Description

Set field type to decimal(12,2) then change field type back to string and Kylo creates string(12,2) hive field type.
This mistake is realized when the Hive create table statement is generated with
<field name> string(12,2),

Environment

AMI 0.7.1

Activity

Show:
Douglas Moore
April 19, 2017, 2:49 AM

CREATE TABLE IF NOT EXISTS `freddie_mac`.`loan_performance_sample_v6`
(`loan_sequence_number` string,
`monthly_reporting_period` date,
`current_actual_upb` decimal(12,2),
`current_loan_delinquency_status` string,
`loan_age` int, `remaining_months_to_legal_maturity` int,
`repurchase_flag` boolean, `modification_flag` boolean,
`zero_balance_code` string,
`zero_balance_effective_date` date,
`current_interest_rate` decimal(6,3),
`current_deferred_upb` decimal(12,2),
`ddlpi` date,
`mi_recoveries` decimal(12,2),
`net_sales_proceeds`string(12,2),
`non_mi_recoveries` decimal(12,2),
`expenses` decimal(12,2),
`legal_costs` decimal(12,2),
`maintenance_and_preservation_costs` decimal(12,2),
`taxes_and_insurance` decimal(12,2), `miscellaneous_expenses` decimal(12,2),
`actual_loss_calculation` decimal(12,2), `modification_cost` decimal(12,2),
processing_dttm string)
STORED AS ORC LOCATION '/app/warehouse/freddie_mac/loan_performance_sample_v6'
tblproperties("orc.compress"="SNAPPY")

Done

Assignee

Scott Reisdorf

Reporter

Douglas Moore

Labels

None

Reviewer

None

Story point estimate

None

Components

Sprint

None

Fix versions

Priority

Medium