question Re: When the table's new record count updated, we unable to get the incremental record count after Kerberos Authentication implementation and Ranger Installation in Support Questions

Incremental record count after Kerberos Authentication implementation and Ranger Installation

Choolake — Tue, 21 Apr 2026 06:52:20 GMT

Hi.....

We are using following commands to get the updated records count in our table after Kerberos Authentication implementation and Ranger Installation.

We get count1 variable before update the table

count1=$(beeline -u "jdbc:hive2://dev-lisa.realm.com:10000/default;principal=hive/dev-lisa.intranet.slt.com.lk@REALM.COM;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks" -n hadoopuser02 -e 'SELECT count(*) from table_name; ')

We get count2 variable after update the table

count2=$(beeline -u "jdbc:hive2://dev-lisa.realm.com:10000/default;principal=hive/dev-lisa.intranet.slt.com.lk@REALM.COM;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks" -n hadoopuser02 -e 'SELECT count(*) from table_name; ')

entries=$(echo "$count2-$count1")

we unable to get the "entries" value into variable. please support to fix this.

Re: When the table's new record count updated, we unable to get the incremental record count after Kerberos Authentication implementation and Ranger Installation

smruti — Wed, 21 Jun 2023 13:39:10 GMT

@Choolake Try :

entries=$((count2-count1))

This should work provided we have valid values on both variables.

Re: When the table's new record count updated, we unable to get the incremental record count after Kerberos Authentication implementation and Ranger Installation

Choolake — Thu, 22 Jun 2023 07:18:28 GMT

Thank you for the support comment. still issue not fixed. i think there is an issue in count1 and count2 getting commands. Please support?

Re: Incremental record count after Kerberos Authentication implementation and Ranger Installation

smruti — Wed, 28 Jun 2023 18:31:21 GMT

@Choolake Try this:

count1=$(beeline -u "jdbc:hive2://dev-lisa.realm.com:10000/default;principal=hive/dev-lisa.intranet.slt.com.lk@REALM.COM;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks" --showHeader=false --silent=true --outputformat=tsv2 -e 'SELECT count(*) from table_name;')

These beeline flags will remove all the unnecessary texts from the stdout. Compute count2 the same way.

Re: Incremental record count after Kerberos Authentication implementation and Ranger Installation

Choolake — Fri, 30 Jun 2023 05:26:50 GMT

Great... Thank you very much!

it's working....