For the most part it is resolved by kinit - R command from the shell prompt. We also created a script to renew the Kerberos ticket daily. But there were couple of instances when I still see this issue. Especially for Hive table in parquet format.
On Tue, Jul 5, 2016 at 8:05 AM, Joseph Swingle <joeswin...@gmail.com> wrote: > Did you get this resolved? I have the same issue > > On Sun, Jul 3, 2016 at 10:49 PM, Santosh Kulkarni < > santoshskulkarn...@gmail.com> wrote: > > > Hello, > > > > For a simple query select count(*) from table_name, Drill gives an error. > > Error: SYSTEM ERROR: IOException: Can't get Master Kerberos principal for > > use as renewer. > > > > I also ran the kinit -kt command and confirmed the ticket is active. > > > > So, if the Kerberos ticket is active and if I can query few other tables > > why Drill gives error for certain tables although the file formats, > > compression, table type are the same? Number of columns in this table is > > 273. Does Drill has any limitations on the number of columns? > > > > Tried select count(col1) from table_name, it gives the same error. > > > > Another observation: > > Describe table_name in hive and Drill shows different datatypes for the > > columns. > > e.g. String, tinyint in Hive shows as Character varying and Integer in > > Drill. Is this by Design? > > > > Appreciate your help. > > > > Thanks, > > > > Santosh > > >