Hi Everyone,
I wrote a storm-hive bolt which has a json data as follows:
h,i
h,e,l,l,o
and my DDL is
CREATE TABLE delimeter
(
json string
)
CLUSTERED BY (json) INTO 5 BUCKETS
STORED AS ORC
TBLPROPERTIES
(
"transactional"="true",
"orc.compress"="SNAPPY"
);
The issue I am facing is I am only getting the data before comma in table.
output: h
In hivebolt I tried sending the different types of delimiter’s instead
of comma(,) like (|,!,@,#,%,^,&,*,^A,^B,!@#,!$) These were also not
giving an expected output.
DelimitedRecordHiveMapper mapper = new DelimitedRecordHiveMapper()
.withColumnFields(new Fields(colNames))
.withFieldDelimiter(delimiter);
Any suggestions/help would be appreciable!
Thanks
Sowjanya