Flight connector on helm chart after enabled tls flight gettting error

@rymurr, i have tested flight connector with akscluster with helm,its working if i does not enabled dremio-tls-secret-ui i able to query with flight.
But,as soon as enabled dremio-tls-secret-ui = true in value.yml and deploy cluster i am getting below error in python

FlightServerError Traceback (most recent call last)
in
42 client = flight.FlightClient(‘grpc+tcp://integdremio.visur.tech:47470’)
43
—> 44 client.authenticate(HttpDremioClientAuthHandler(username, password))
45 info = client.get_flight_info(flight.FlightDescriptor.for_command(sql))
46

~\AppData\Local\Programs\Python\Python37\lib\site-packages\pyarrow_flight.pyx in pyarrow._flight.FlightClient.authenticate()

~\AppData\Local\Programs\Python\Python37\lib\site-packages\pyarrow_flight.pyx in pyarrow._flight.check_flight_status()

FlightServerError: Flight RPC failed with message: Stream removed

here is code ’
"
client = flight.FlightClient(‘grpc+tcp://:47470’)

client.authenticate(HttpDremioClientAuthHandler(username, password))
info = client.get_flight_info(flight.FlightDescriptor.for_command(sql))

reader = client.do_get(info.endpoints[0].ticket)
batches = []
while True:
try:
batch, metadata = reader.read_chunk()
batches.append(batch)
except StopIteration:
break
data = pa.Table.from_batches(batches)

panda data frame

pdf = data.to_pandas()
#pdf = json.read_json(reader)
#pdf =data.to_json()
pdf.head()
print(pdf)
"

1 Like

isses solved by adding root crt file and pass as argument in authentication

1 Like

Hi Vikash, can you share the code or the steps to add a root crt file and pass as argument in authentication? I’m on a windows system here.