· 7 years ago · Feb 19, 2019, 12:40 AM
1$ python analyse/data.py
2<Hana connection host=zeus.hana.prod.eu-central-1.whitney.dbaas.ondemand.com port=21830 user=SOLID>
3Empty DataFrame
4Columns: [ID, NUMBER, ROUTE_ID]
5Index: []
6Traceback (most recent call last):
7 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pandas/io/sql.py", line 1378, in execute
8 cur.execute(*args)
9 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/cursor.py", line 260, in execute
10 self.executemany(statement, parameters=[parameters])
11 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/cursor.py", line 271, in executemany
12 statement_id = self.prepare(statement)
13 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/cursor.py", line 152, in prepare
14 response = self.connection.send_request(request)
15 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/connection.py", line 102, in send_request
16 return self.__send_message_recv_reply(payload.getvalue())
17 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/connection.py", line 142, in __send_message_recv_reply
18 return ReplyMessage.unpack_reply(header, payload)
19 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/protocol/message.py", line 92, in unpack_reply
20 segments=tuple(ReplySegment.unpack_from(payload, expected_segments=header.num_segments)),
21 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/protocol/segments.py", line 152, in unpack_from
22 raise error.parts[0].errors[0]
23pyhdb.exceptions.DatabaseError: invalid table name: Could not find table/view SQLITE_MASTER in schema SOLID: line 1 col 18 (at pos 17)
24
25During handling of the above exception, another exception occurred:
26
27Traceback (most recent call last):
28 File "analyse/data.py", line 204, in <module>
29 write_table_pyhdb()
30 File "analyse/data.py", line 173, in write_table_pyhdb
31 df.to_sql("spam2", connection, if_exists="replace")
32 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pandas/core/generic.py", line 2130, in to_sql
33 dtype=dtype)
34 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pandas/io/sql.py", line 450, in to_sql
35 chunksize=chunksize, dtype=dtype)
36 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pandas/io/sql.py", line 1480, in to_sql
37 table.create()
38 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pandas/io/sql.py", line 561, in create
39 if self.exists():
40 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pandas/io/sql.py", line 549, in exists
41 return self.pd_sql.has_table(self.name, self.schema)
42 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pandas/io/sql.py", line 1492, in has_table
43 return len(self.execute(query, [name, ]).fetchall()) > 0
44 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pandas/io/sql.py", line 1390, in execute
45 raise_with_traceback(ex)
46 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pandas/compat/__init__.py", line 404, in raise_with_traceback
47 raise exc.with_traceback(traceback)
48 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pandas/io/sql.py", line 1378, in execute
49 cur.execute(*args)
50 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/cursor.py", line 260, in execute
51 self.executemany(statement, parameters=[parameters])
52 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/cursor.py", line 271, in executemany
53 statement_id = self.prepare(statement)
54 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/cursor.py", line 152, in prepare
55 response = self.connection.send_request(request)
56 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/connection.py", line 102, in send_request
57 return self.__send_message_recv_reply(payload.getvalue())
58 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/connection.py", line 142, in __send_message_recv_reply
59 return ReplyMessage.unpack_reply(header, payload)
60 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/protocol/message.py", line 92, in unpack_reply
61 segments=tuple(ReplySegment.unpack_from(payload, expected_segments=header.num_segments)),
62 File "/Users/deil/software/anaconda3/envs/hackdays/lib/python3.7/site-packages/pyhdb/protocol/segments.py", line 152, in unpack_from
63 raise error.parts[0].errors[0]
64pandas.io.sql.DatabaseError: Execution failed on sql 'SELECT name FROM sqlite_master WHERE type='table' AND name=?;': invalid table name: Could not find table/view SQLITE_MASTER in schema SOLID: line 1 col 18 (at pos 17)