MinuraPunchihewa opened a new issue, #9185:
URL: https://github.com/apache/pinot/issues/9185

   I have been trying to connect to Apache Pinot using the Python client 
[pinotdb](https://github.com/python-pinot-dbapi/pinot-dbapi) for quite a while 
now, to no avail. 
   
   I am simply running Pinot as a Docker container using the following command,
   `docker run -p 9000:9000 apachepinot/pinot:0.9.3 QuickStart -type hybrid`
   
   Given below is what my Python code looks like,
   ```
   from pinotdb import connect
   
   conn = connect(host='localhost', port=9000, path='/query/sql', scheme='http')
   curs = conn.cursor()
   curs.execute("""
       SELECT * FROM airlineStats
   """)
   ```
   Every time I run this, I get the following error,
   `AttributeError: 'NoneType' object has no attribute '_username'`
   
   Is there a default username or password that comes with Pinot or is there 
some way that I can create a user? It looks like the problem is that a username 
is somehow required.
   
   I realize that I this may not be the right place to raise this issue, but I 
have already created an issue on the pinotdb repository, but I am yet to 
receive a response.
   
   Any help on this matter would be greatly appreciated.
   
   Here is the complete stack trace of the error I am facing, 
   ```
   ---------------------------------------------------------------------------
   AttributeError                            Traceback (most recent call last)
   Input In [12], in <cell line: 1>()
   ----> 1 curs.execute("""
         2     SELECT * FROM airlineStats
         3 """)
         4 for row in curs:
         5     print(row)
   
   File ~\Anaconda3\envs\pinotdb\lib\site-packages\pinotdb\db.py:56, in 
check_closed.<locals>.g(self, *args, **kwargs)
        54 if self.closed:
        55     raise exceptions.Error(f"{self.__class__.__name__} already 
closed")
   ---> 56 return f(self, *args, **kwargs)
   
   File ~\Anaconda3\envs\pinotdb\lib\site-packages\pinotdb\db.py:448, in 
Cursor.execute(self, operation, parameters)
       441 @check_closed
       442 def execute(self, operation, parameters=None):
       443     query = self.finalize_query_payload(operation, parameters)
       445     r = self.session.post(
       446         self.url,
       447         json=query,
   --> 448         auth=(self.auth._username, self.auth._password))
       449     return self.normalize_query_response(query, r)
   
   AttributeError: 'NoneType' object has no attribute '_username'
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org

Reply via email to