@ChineduLB , Did you mean that you got the same error while trying to export the sample data you provided earlier? Have you tried to update your driver in case it might be old? Cheers Eric ... View more

@ChineduLB Can you please share below info: - the DDL of the table in Teradata - some sample data from the file in HDFS It looks to me some issues in the data, I suggest you also narrow down the issue by slowly reducing the number of columns from the file and see which one is actually causing the issue and which rows. Cheers Eric ... View more

@Manus , Can you please share the error from Beeline and HS2 log? Without them, it is difficult to see what is going on. Cheers Eric ... View more

Hi Choon Kiat, Thanks for the confirmation. I have checked further, "Unable to obtain Principal Name for authentication" can happen when the JCE jars are not up to date on the client machine and not able to use the encryption key provided by Kerberos KDC. Can you please download the latest/appropriate JCE jars and place them in directory $JAVA_HOME/jre/lib/security. The files are: US_export_policy.jar local_policy.jar These files are dependent on the Java version. For Java8, it can be found here: https://www.oracle.com/java/technologies/javase-jce8-downloads.html Please give it a try and see how it goes. Regards Eric ... View more

Hi Gabor, Can you share the krb5.conf file on the HMS host for review? Cheers Eric ... View more

Hi Your JDBC connection string: jdbc:hive2://{host}:{port}/{database};AuthMech=1;KrbRealm=Domain;KrbHostFQDN={server};KrbServiceName=hive;KrbAuthType=2;LogLevel=6;LogPath=c:\ProgramData\MIT\Kerberos5\log.log Is "Domain" the real string or a placeholder? From your krb5, your Realm should be "AIU.XXXXXX", so I want to confirm. Cheers Eric ... View more

@TanChoonKiat Your JDBC Connection string is wrong, assuming that you are using Cloudera Hive JDBC Driver: jdbc:hive2://xx.xx.xxx.xx:10001/default;AuthMech=1;principal=hive/domain@domain;KrbHostFQDN=10.11.121.21;KrbServiceName=hive;KrbAuthType=2;LogLevel=6;LogPath=c:\ProgramData\MIT\Kerberos5\log.log 1. No need for "principal" 2. Can you please check what's the full principals from your KDC server? KrbHostFQDN should be normally the domain name, not IP. 3. you are missing KrbRealm, which should be the part after "@" from your principal Please try to correct those and try again. Full JDBC doc can be found here: https://docs.cloudera.com/documentation/other/connectors/hive-jdbc/latest/Cloudera-JDBC-Driver-for-Apache-Hive-Install-Guide.pdf Cheers Eric ... View more

@TanChoonKiat Can you please share your JDBC connection string? Cheers Eric ... View more

Please use the query ID hive_20200308155555_9a444e04-9523-4443-b312-64a94e5a5138 and search in HS2 log to find out the exact reason for the failure. Looks like beeline did not capture the full error from server side. Cheers Eric ... View more

Hi @Dombai_Gabor, Can you check the keytab file under /var/run/cloudera-scm-agent/process/*HIVEMETASTORE* directories are valid and you can kinit using those keytab files without issues? Also, does the error happen on start up or after running for a while? Thanks Eric ... View more