topic Re: How does Data Typing work in Splunk and Hunk? in All Apps and Add-ons

How does Data Typing work in Splunk and Hunk?

ddrillic — Sun, 01 May 2016 19:14:15 GMT

I wonder about data typing in Splunk/Hunk.

We had the case of exporting ssns to a csv file -
In this case the ssn is defined as String in Hive, but since it's comprised almost exclusively of digits, it's being treated as a number within Hunk.

Is this the expected behavior?

Re: How does Data Typing work in Splunk and Hunk?

ddrillic — Thu, 05 May 2016 15:27:04 GMT

Any thoughts, by any chance?

Re: How does Data Typing work in Splunk and Hunk?

Ledion_Bitincka — Thu, 05 May 2016 17:12:15 GMT

Not sure exactly what you mean about ssn being treated as numbers in Splunk/Hunk, can you please elaborate on what issues is this causing? SPL is loosely typed, ie each command will convert/cast field values into the type that it needs.

Re: How does Data Typing work in Splunk and Hunk?

ddrillic — Thu, 05 May 2016 19:25:22 GMT

Thank you Ledion. In Exporting SSNs to a CSV file trims leading zeros

we spoke about the SSN issue. The thing is that with Hunk when using Hive, we specify the data type and Splunk defines the data type ignoring the Hive data type. It leads to a situation, where the SSN values are being modified when exported out, or being treated as numbers within Splunk.

Does it make sense?