apache drill 1.10.0
"drill baby drill"
0: jdbc:drill:zk=titana-ch2-p3:5181/drill/TIT> use sys;
+-------+----------------------------------+
|  ok   |             summary              |
+-------+----------------------------------+
| true  | Default schema changed to [sys]  |
+-------+----------------------------------+
1 row selected (0.975 seconds)
0: jdbc:drill:zk=titana-ch2-p3:5181/drill/TIT> select version from version;
+----------+
| version  |
+----------+
| 1.10.0   |
+----------+
1 row selected (0.409 seconds)
0: jdbc:drill:zk=titana-ch2-p3:5181/drill/TIT>
0: jdbc:drill:zk=titana-ch2-p3:5181/drill/TIT> select * from users.`sbalas002c`.drill_spl_char;
+------------------------+--------------------------------------------------------------+
| ORIG_CAMPAIGN_LINE_ID  |                   ORIG_CAMPAIGN_LINE_NAME                    |
+------------------------+--------------------------------------------------------------+
| 30092278               | 1573256-1_306774_SeattleTheatreGroup�_201901_ISV_SEA_Z_SSEA  |
| 30092282               | 1573257-1_306774_SeattleTheatreGroup�_201901_ISV_SEA_Z_WORD  |
| 30092286               | 1573254-1_306774_SeattleTheatreGroup�_201901_ISV_SEA_Z_BLIS  |
| 30092290               | 1573255-1_306774_SeattleTheatreGroup�_201901_ISV_SEA_Z_NSEA  |
+------------------------+--------------------------------------------------------------+
4 rows selected (0.445 seconds)
0: jdbc:drill:zk=titana-ch2-p3:5181/drill/TIT>
0: jdbc:drill:zk=titana-ch2-p3:5181/drill/TIT> select ORIG_CAMPAIGN_LINE_NAME,
. . . . . . . . . . . . . . . . . . . . . . .> substr(ORIG_CAMPAIGN_LINE_NAME,1,4) sub_CAMPAIGN_LINE_NAME
. . . . . . . . . . . . . . . . . . . . . . .> from users.`sbalas002c`.drill_spl_char;
Error: SYSTEM ERROR: DrillRuntimeException: Unexpected byte 0xa0 at position 36 encountered while decoding UTF8 string.

Fragment 0:0

[Error Id: 1889163a-f847-48ad-a7a9-bbe4284e112c on titand-ch2-p20.cable.comcast.com:31010] (state=,code=0)
0: jdbc:drill:zk=titana-ch2-p3:5181/drill/TIT>
0: jdbc:drill:zk=titana-ch2-p3:5181/drill/TIT> select ORIG_CAMPAIGN_LINE_NAME,
. . . . . . . . . . . . . . . . . . . . . . .>  STRING_BINARY(ORIG_CAMPAIGN_LINE_NAME) SB_CAMPAIGN_LINE_NAME,
. . . . . . . . . . . . . . . . . . . . . . .>  regexp_replace(STRING_BINARY(ORIG_CAMPAIGN_LINE_NAME),'\xA0','') Good_CAMPAIGN_LINE_NAME
. . . . . . . . . . . . . . . . . . . . . . .> from users.`sbalas002c`.drill_spl_char;
+--------------------------------------------------------------+-----------------------------------------------------------------+-------------------------------------------------------------+
|                   ORIG_CAMPAIGN_LINE_NAME                    |                      SB_CAMPAIGN_LINE_NAME                      |                   Good_CAMPAIGN_LINE_NAME                   |
+--------------------------------------------------------------+-----------------------------------------------------------------+-------------------------------------------------------------+
| 1573256-1_306774_SeattleTheatreGroup�_201901_ISV_SEA_Z_SSEA  | 1573256-1_306774_SeattleTheatreGroupxA0_201901_ISV_SEA_Z_SSEA  | 1573256-1_306774_SeattleTheatreGroup_201901_ISV_SEA_Z_SSEA  |
| 1573257-1_306774_SeattleTheatreGroup�_201901_ISV_SEA_Z_WORD  | 1573257-1_306774_SeattleTheatreGroupxA0_201901_ISV_SEA_Z_WORD  | 1573257-1_306774_SeattleTheatreGroup_201901_ISV_SEA_Z_WORD  |
| 1573254-1_306774_SeattleTheatreGroup�_201901_ISV_SEA_Z_BLIS  | 1573254-1_306774_SeattleTheatreGroupxA0_201901_ISV_SEA_Z_BLIS  | 1573254-1_306774_SeattleTheatreGroup_201901_ISV_SEA_Z_BLIS  |
| 1573255-1_306774_SeattleTheatreGroup�_201901_ISV_SEA_Z_NSEA  | 1573255-1_306774_SeattleTheatreGroupxA0_201901_ISV_SEA_Z_NSEA  | 1573255-1_306774_SeattleTheatreGroup_201901_ISV_SEA_Z_NSEA  |
+--------------------------------------------------------------+-----------------------------------------------------------------+-------------------------------------------------------------+
4 rows selected (0.64 seconds)
0: jdbc:drill:zk=titana-ch2-p3:5181/drill/TIT>

Hope this helps others.