Affects Version/s: 0.4.0, 0.5.0
Fix Version/s: None
The %sql drops leading zeros from columns with String datatype.
Consider the following test data:
Created as an external table in Hive using:
and accessed using the following scala (%livy) code:
and the following sql in the same notebook:
The result is the following (note the missing zero on the first record):
The output of the scala code does, however, display the leading zero.
Also note the data types from the print schema: ID is a String.