Python Forum
python script for inserting rows into hbase table - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: python script for inserting rows into hbase table (/thread-10443.html)



python script for inserting rows into hbase table - lravikumarvsp - May-21-2018

Hi,

I want to insert multiple rows into hbase table using for loop.

Please help


RE: python script for inserting rows into hbase table - buran - May-21-2018

Please, don't post any more questions expecting we would do it for you. Post your code in python tags, any traceback, if you get one, in error tags.
I already gave you link to the respective package docs in a previous hbase related post and you didn't care to respond. Did you read it? What have you tried so far?
If you have difficulty finding the link - here it is again:
https://happybase.readthedocs.io/en/latest/

For this question: https://happybase.readthedocs.io/en/latest/api.html#happybase.Table.put


RE: python script for inserting rows into hbase table - lravikumarvsp - May-22-2018

I am not expecting anyone to write a code for me.
I need a suggestion.
I had a script for inserting data into hbase table.
import glob
import connect_to_hbase
import os
import csv
import testingsun1
#Changing to the directory path to search for the directory name containing "GSK"

table = connect_to_hbase.conn.table(connect_to_hbase.table_name_Target)
base_path = '/ai2/data/dev/admin/inf/*{}*'
patterns = testingsun1.z

#x = table.row(row.serialnum) 
for pattern in patterns:
	
	search_path =  base_path.format(pattern)
	for f in glob.glob(search_path):
		print("-----------------------")
		print ("The directory path is:")
		print f
		print("List of files in the directory are:")
		os.chdir('/ai2/data/dev/admin/inf/')
    		os.chdir(f)
    		cwd = os.getcwd()
		for subdir, dirs, files in os.walk(cwd, topdown=True):
				for file23 in glob.glob('*.err'):
					print file23
					with open(file23) as f:
						strings = f.read()
						search_word = 'checksum'
						search_word1 = 'Threshold'				
						if(search_word1 in strings):
							with open('/ai2/data/dev/serial/sys/sys_ath_pvt/main/qv_thresholdhistory.csv','r') as csvfile:
								readCSV = csv.reader(csvfile, delimiter=',')
								next(readCSV, None)
								for row in readCSV:
									#print row[2]
									#print os.path.splitext(file23)[0]
									if(os.path.splitext(file23)[0] in row[2]):
										if row[5] and row[9]:
											if(int(row[5]) - int(row[9]) >= 0):
												a = row[3].split("|")
												b = row[4].split("|")
												recom=b[1]
												app_id=row[0]
												entity=row[2]
												existing=a[1]
												data_control=search_word1
												store=recom,app_id,entity,existing,data_control
												print(store)
												table.put('row-key', {'APP_VALUES:SEGMENT':'','APP_VALUES:API_KEY':'','APP_VALUES:RECOMMENDED_VALUE':store[0], 'APP_VALUES:APPLICATION_NAME':store[1],'APP_VALUES:ENTITY_NAME':store[2],'APP_VALUES:EXISTING_VALUE':store[3],'APP_VALUES:DATA_CONTROL':store[4],'APP_VALUES:APPLICATION_ID':store[1]})
											
									
						else:
							print ("word not found")
In the above code print (store) is printing all the values which are to be inserted into the hbase table.
But table.put statement is inserting only the last output value of the print (store) statement.

Print store output:
Output:
The directory path is: /ai2/data/dev/admin/inf/inf_DRM_pvt List of files in the directory are: call_report_y9clookup.err ('0', 'drm', 'call_report_y9clookup', '300', 'Threshold') ----------------------- The directory path is: /ai2/data/dev/admin/inf/inf_GSK_pvt List of files in the directory are: gs_attribute.err word not found ----------------------- The directory path is: /ai2/data/dev/admin/inf/inf_IPT_pvt List of files in the directory are: run_ingest_IPT_daily_1246.err word not found ----------------------- The directory path is: /ai2/data/dev/admin/inf/inf_XU0_pvt List of files in the directory are: t_itm.err ('12', 'xu0', 't_itm', '500', 'Threshold')
Data inserted in the table:
Output:
1.8.7-p357 :030 > scan 'TMP_ATLAS_DSCVRY_APPS' ROW COLUMN+CELL row-key column=APP_VALUES:API_KEY, timestamp=1526959583897, value= row-key column=APP_VALUES:APPLICATION_ID, timestamp=1526959583897, value=xu0 row-key column=APP_VALUES:APPLICATION_NAME, timestamp=1526959583897, value=xu0 row-key column=APP_VALUES:DATA_CONTROL, timestamp=1526959583897, value=Threshold row-key column=APP_VALUES:ENTITY_NAME, timestamp=1526959583897, value=t_itm row-key column=APP_VALUES:EXISTING_VALUE, timestamp=1526959583897, value=500 row-key column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526959583897, value=12 row-key column=APP_VALUES:SEGMENT, timestamp=1526959583897, value= 1 row(s) in 0.3440 seconds
Where I am doing wrong?
Please suggest.

Thanks


RE: python script for inserting rows into hbase table - buran - May-22-2018

On line 50: the first argument to table.put you don't change the first argument which is row. So with each iteration you in fact overwrite previous values. You need to change this row key for each row.


RE: python script for inserting rows into hbase table - lravikumarvsp - May-22-2018

Hi

I tried in that way also, still getting the same.

import glob
import connect_to_hbase
import os
import csv
import testingsun1
#Changing to the directory path to search for the directory name containing "GSK"

table = connect_to_hbase.conn.table(connect_to_hbase.table_name_Target)
base_path = '/ai2/data/dev/admin/inf/*{}*'
patterns = testingsun1.z

#x = table.row(row.serialnum) 
for pattern in patterns:
	
	search_path =  base_path.format(pattern)
	for f in glob.glob(search_path):
		print("-----------------------")
		print ("The directory path is:")
		print f
		print("List of files in the directory are:")
		os.chdir('/ai2/data/dev/admin/inf/')
    		os.chdir(f)
    		cwd = os.getcwd()
		for subdir, dirs, files in os.walk(cwd, topdown=True):
				for file23 in glob.glob('*.err'):
					print file23
					with open(file23) as f:
						strings = f.read()
						search_word = 'checksum'
						search_word1 = 'Threshold'				
						if(search_word1 in strings):
							with open('/ai2/data/dev/serial/sys/sys_ath_pvt/main/qv_thresholdhistory.csv','r') as csvfile:
								readCSV = csv.reader(csvfile, delimiter=',')
								next(readCSV, None)
								for row in readCSV:
									#print row[2]
									#print os.path.splitext(file23)[0]
									if(os.path.splitext(file23)[0] in row[2]):
										if row[5] and row[9]:
											if(int(row[5]) - int(row[9]) >= 0):
												a = row[3].split("|")
												b = row[4].split("|")
												recom=b[1]
												app_id=row[0]
												entity=row[2]
												existing=a[1]
												data_control=search_word1
												store=recom,app_id,entity,existing,data_control
												print(store)
												for i in range(20):
												table.put('row-%04d' % i, {'APP_VALUES:SEGMENT':'','APP_VALUES:API_KEY':'','APP_VALUES:RECOMMENDED_VALUE':a[0], 'APP_VALUES:APPLICATION_NAME':a[10],'APP_VALUES:ENTITY_NAME':a[2],'APP_VALUES:EXISTING_VALUE':a[3],'APP_VALUES:DATA_CONTROL':a[4],'APP_VALUES:APPLICATION_ID':a[1]})
											
									
						else:
							print ("word not found")
									



RE: python script for inserting rows into hbase table - buran - May-22-2018

well, even your indentation is not correct.
And it will not work, because you will just have 20 times the same data - the last row repeated 20 times. You need unique row key for each set of new data


RE: python script for inserting rows into hbase table - lravikumarvsp - May-22-2018

Hi Buran,

How can I insert unique row key in this code
Please help

Thanks

Hi Buran,

Please find the code and output below

import glob
import connect_to_hbase
import os
import csv
import testingsun1
#Changing to the directory path to search for the directory name containing "GSK"

table = connect_to_hbase.conn.table(connect_to_hbase.table_name_Target)
base_path = '/ai2/data/dev/admin/inf/*{}*'
patterns = testingsun1.z

#x = table.row(row.serialnum) 
for pattern in patterns:
	
	search_path =  base_path.format(pattern)
	for f in glob.glob(search_path):
		print("-----------------------")
		print ("The directory path is:")
		print f
		print("List of files in the directory are:")
		os.chdir('/ai2/data/dev/admin/inf/')
    		os.chdir(f)
    		cwd = os.getcwd()
		for subdir, dirs, files in os.walk(cwd, topdown=True):
				for file23 in glob.glob('*.err'):
					print file23
					with open(file23) as f:
						strings = f.read()
						search_word = 'checksum'
						search_word1 = 'Threshold'				
						if(search_word1 in strings):
							with open('/ai2/data/dev/serial/sys/sys_ath_pvt/main/qv_thresholdhistory.csv','r') as csvfile:
								readCSV = csv.reader(csvfile, delimiter=',')
								next(readCSV, None)
								for row in readCSV:
									#print row[2]
									#print os.path.splitext(file23)[0]
									if(os.path.splitext(file23)[0] in row[2]):
										if row[5] and row[9]:
											if(int(row[5]) - int(row[9]) >= 0):
												a = row[3].split("|")
												b = row[4].split("|")
												recom=b[1]
												app_id=row[0]
												entity=row[2]
												existing=a[1]
												data_control=search_word1
												store=recom,app_id,entity,existing,data_control
												print(store)
												for i in range(20):
													table.put('row-%04d' % i, {'APP_VALUES:SEGMENT':'','APP_VALUES:API_KEY':'','APP_VALUES:RECOMMENDED_VALUE':store[0], 'APP_VALUES:APPLICATION_NAME':store[1],'APP_VALUES:ENTITY_NAME':store[2],'APP_VALUES:EXISTING_VALUE':store[3],'APP_VALUES:DATA_CONTROL':store[4],'APP_VALUES:APPLICATION_ID':store[1]})
											
									
						else:
							print ("word not found")
									
Output:
row-0000 column=APP_VALUES:API_KEY, timestamp=1526970471014, value= row-0000 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471014, value=xu0 row-0000 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471014, value=xu0 row-0000 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471014, value=Threshold row-0000 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471014, value=t_itm row-0000 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471014, value=500 row-0000 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471014, value=12 row-0000 column=APP_VALUES:SEGMENT, timestamp=1526970471014, value= row-0001 column=APP_VALUES:API_KEY, timestamp=1526970471016, value= row-0001 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471016, value=xu0 row-0001 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471016, value=xu0 row-0001 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471016, value=Threshold row-0001 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471016, value=t_itm row-0001 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471016, value=500 row-0001 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471016, value=12 row-0001 column=APP_VALUES:SEGMENT, timestamp=1526970471016, value= row-0002 column=APP_VALUES:API_KEY, timestamp=1526970471020, value= row-0002 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471020, value=xu0 row-0002 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471020, value=xu0 row-0002 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471020, value=Threshold row-0002 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471020, value=t_itm row-0002 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471020, value=500 row-0002 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471020, value=12 row-0002 column=APP_VALUES:SEGMENT, timestamp=1526970471020, value= row-0003 column=APP_VALUES:API_KEY, timestamp=1526970471027, value= row-0003 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471027, value=xu0 row-0003 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471027, value=xu0 row-0003 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471027, value=Threshold row-0003 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471027, value=t_itm row-0003 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471027, value=500 row-0003 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471027, value=12 row-0003 column=APP_VALUES:SEGMENT, timestamp=1526970471027, value= row-0004 column=APP_VALUES:API_KEY, timestamp=1526970471029, value= row-0004 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471029, value=xu0 row-0004 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471029, value=xu0 row-0004 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471029, value=Threshold row-0004 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471029, value=t_itm row-0004 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471029, value=500 row-0004 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471029, value=12 row-0004 column=APP_VALUES:SEGMENT, timestamp=1526970471029, value= row-0005 column=APP_VALUES:API_KEY, timestamp=1526970471031, value= row-0005 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471031, value=xu0 row-0005 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471031, value=xu0 row-0005 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471031, value=Threshold row-0005 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471031, value=t_itm row-0005 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471031, value=500 row-0005 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471031, value=12 row-0005 column=APP_VALUES:SEGMENT, timestamp=1526970471031, value= row-0006 column=APP_VALUES:API_KEY, timestamp=1526970471043, value= row-0006 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471043, value=xu0 row-0006 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471043, value=xu0 row-0006 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471043, value=Threshold row-0006 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471043, value=t_itm row-0006 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471043, value=500 row-0006 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471043, value=12 row-0006 column=APP_VALUES:SEGMENT, timestamp=1526970471043, value= row-0007 column=APP_VALUES:API_KEY, timestamp=1526970471052, value= row-0007 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471052, value=xu0 row-0007 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471052, value=xu0 row-0007 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471052, value=Threshold row-0007 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471052, value=t_itm row-0007 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471052, value=500 row-0007 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471052, value=12 row-0007 column=APP_VALUES:SEGMENT, timestamp=1526970471052, value= row-0008 column=APP_VALUES:API_KEY, timestamp=1526970471054, value= row-0008 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471054, value=xu0 row-0008 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471054, value=xu0 row-0008 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471054, value=Threshold row-0008 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471054, value=t_itm row-0008 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471054, value=500 row-0008 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471054, value=12 row-0008 column=APP_VALUES:SEGMENT, timestamp=1526970471054, value= row-0009 column=APP_VALUES:API_KEY, timestamp=1526970471055, value= row-0009 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471055, value=xu0 row-0009 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471055, value=xu0 row-0009 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471055, value=Threshold row-0009 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471055, value=t_itm row-0009 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471055, value=500 row-0009 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471055, value=12 row-0009 column=APP_VALUES:SEGMENT, timestamp=1526970471055, value= row-0010 column=APP_VALUES:API_KEY, timestamp=1526970471057, value= row-0010 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471057, value=xu0 row-0010 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471057, value=xu0 row-0010 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471057, value=Threshold row-0010 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471057, value=t_itm row-0010 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471057, value=500 row-0010 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471057, value=12 row-0010 column=APP_VALUES:SEGMENT, timestamp=1526970471057, value= row-0011 column=APP_VALUES:API_KEY, timestamp=1526970471064, value= row-0011 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471064, value=xu0 row-0011 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471064, value=xu0 row-0011 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471064, value=Threshold row-0011 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471064, value=t_itm row-0011 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471064, value=500 row-0011 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471064, value=12 row-0011 column=APP_VALUES:SEGMENT, timestamp=1526970471064, value= row-0012 column=APP_VALUES:API_KEY, timestamp=1526970471066, value= row-0012 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471066, value=xu0 row-0012 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471066, value=xu0 row-0012 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471066, value=Threshold row-0012 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471066, value=t_itm row-0012 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471066, value=500 row-0012 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471066, value=12 row-0012 column=APP_VALUES:SEGMENT, timestamp=1526970471066, value= row-0013 column=APP_VALUES:API_KEY, timestamp=1526970471068, value= row-0013 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471068, value=xu0 row-0013 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471068, value=xu0 row-0013 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471068, value=Threshold row-0013 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471068, value=t_itm row-0013 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471068, value=500 row-0013 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471068, value=12 row-0013 column=APP_VALUES:SEGMENT, timestamp=1526970471068, value= row-0014 column=APP_VALUES:API_KEY, timestamp=1526970471069, value= row-0014 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471069, value=xu0 row-0014 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471069, value=xu0 row-0014 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471069, value=Threshold row-0014 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471069, value=t_itm row-0014 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471069, value=500 row-0014 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471069, value=12 row-0014 column=APP_VALUES:SEGMENT, timestamp=1526970471069, value= row-0015 column=APP_VALUES:API_KEY, timestamp=1526970471071, value= row-0015 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471071, value=xu0 row-0015 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471071, value=xu0 row-0015 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471071, value=Threshold row-0015 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471071, value=t_itm row-0015 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471071, value=500 row-0015 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471071, value=12 row-0015 column=APP_VALUES:SEGMENT, timestamp=1526970471071, value= row-0016 column=APP_VALUES:API_KEY, timestamp=1526970471073, value= row-0016 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471073, value=xu0 row-0016 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471073, value=xu0 row-0016 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471073, value=Threshold row-0016 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471073, value=t_itm row-0016 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471073, value=500 row-0016 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471073, value=12 row-0016 column=APP_VALUES:SEGMENT, timestamp=1526970471073, value= row-0017 column=APP_VALUES:API_KEY, timestamp=1526970471074, value= row-0017 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471074, value=xu0 row-0017 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471074, value=xu0 row-0017 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471074, value=Threshold row-0017 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471074, value=t_itm row-0017 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471074, value=500 row-0017 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471074, value=12 row-0017 column=APP_VALUES:SEGMENT, timestamp=1526970471074, value= row-0018 column=APP_VALUES:API_KEY, timestamp=1526970471076, value= row-0018 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471076, value=xu0 row-0018 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471076, value=xu0 row-0018 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471076, value=Threshold row-0018 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471076, value=t_itm row-0018 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471076, value=500 row-0018 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471076, value=12 row-0018 column=APP_VALUES:SEGMENT, timestamp=1526970471076, value= row-0019 column=APP_VALUES:API_KEY, timestamp=1526970471078, value= row-0019 column=APP_VALUES:APPLICATION_ID, timestamp=1526970471078, value=xu0 row-0019 column=APP_VALUES:APPLICATION_NAME, timestamp=1526970471078, value=xu0 row-0019 column=APP_VALUES:DATA_CONTROL, timestamp=1526970471078, value=Threshold row-0019 column=APP_VALUES:ENTITY_NAME, timestamp=1526970471078, value=t_itm row-0019 column=APP_VALUES:EXISTING_VALUE, timestamp=1526970471078, value=500 row-0019 column=APP_VALUES:RECOMMENDED_VALUE, timestamp=1526970471078, value=12 row-0019 column=APP_VALUES:SEGMENT, timestamp=1526970471078, value=



RE: python script for inserting rows into hbase table - parth_botadara - Mar-24-2023

HI @arvikumar can you please send me thi file or please tell me about what you write in script of 'connect_to_hbase' and "testingsun1"