no such table: #17
Assignees
Comments
|
Hi |
|
2020-10-22 23:33:25,840 (38148/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:33:25,841 (38148/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
@
"app.log" 84L, 34906C
2020-10-22 23:33:25,840 (38148/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:33:25,841 (38148/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:40:17,880 (38148/MainThread) lakecli.main ERROR - sql:
'SELECT * FROM maxdb;', error: OperationalError('no such table: maxdb')
2020-10-22 23:33:25,840 (38148/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:33:25,841 (38148/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:40:17,880 (38148/MainThread) lakecli.main ERROR - sql:
'SELECT * FROM maxdb;', error: OperationalError('no such table: maxdb')
2020-10-22 23:40:17,880 (38148/MainThread) lakecli.main ERROR - sql:
'SELECT * FROM maxdb;', error: OperationalError('no such table: maxdb')
…On Sun, Oct 25, 2020 at 7:42 AM Rajat Venkatesh ***@***.***> wrote:
Hi
Thanks for trying out lakecli. Lakecli writes logs to ~/.lakecli/app.log
. Can you check if there are any errors in the log?
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
<#17 (comment)>, or
unsubscribe
<https://github.com/notifications/unsubscribe-auth/AHTW7AJ4CBU2TPX2RM7K4GLSMQMLJANCNFSM4S57TN3A>
.
|
|
any update?
…On Sun, Oct 25, 2020 at 1:57 PM Yingyou ***@***.***> wrote:
2020-10-22 23:33:25,840 (38148/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:33:25,841 (38148/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
@
"app.log" 84L, 34906C
2020-10-22 23:33:25,840 (38148/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:33:25,841 (38148/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:40:17,880 (38148/MainThread) lakecli.main ERROR - sql:
'SELECT * FROM maxdb;', error: OperationalError('no such table: maxdb')
2020-10-22 23:33:25,840 (38148/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:33:25,841 (38148/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:40:17,880 (38148/MainThread) lakecli.main ERROR - sql:
'SELECT * FROM maxdb;', error: OperationalError('no such table: maxdb')
2020-10-22 23:40:17,880 (38148/MainThread) lakecli.main ERROR - sql:
'SELECT * FROM maxdb;', error: OperationalError('no such table: maxdb')
On Sun, Oct 25, 2020 at 7:42 AM Rajat Venkatesh ***@***.***>
wrote:
> Hi
> Thanks for trying out lakecli. Lakecli writes logs to ~/.lakecli/app.log
> . Can you check if there are any errors in the log?
>
> —
> You are receiving this because you authored the thread.
> Reply to this email directly, view it on GitHub
> <#17 (comment)>, or
> unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AHTW7AJ4CBU2TPX2RM7K4GLSMQMLJANCNFSM4S57TN3A>
> .
>
|
|
Can you run with --scan ? This is required the first time to create and load the tables. |
|
~ ❯ lakecli --scan
\r:iamdb> select * from database_privileges;
0 rows in set
Time: 0.000s
\r:iamdb> select * from table_privileges;
0 rows in set
Time: 0.000s
\r:iamdb>
but I have databases and tables there, why they cannot be seen?
…On Mon, Oct 26, 2020 at 2:13 AM Rajat Venkatesh ***@***.***> wrote:
Can you run with --scan ? This is required the first time to create and load the tables.
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub, or unsubscribe.
|
|
Can you paste the logs for the run with --scan ? |
|
~/.lakecli ❯ vim app.log
2020-10-22 23:33:25,840 (38148/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:33:25,841 (38148/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:40:17,880 (38148/MainThread) lakecli.main ERROR - sql:
'SELECT * FROM maxdb;', error: OperationalError('no such table: maxdb')
2020-10-22 23:40:17,880 (38148/MainThread) lakecli.main ERROR - sql:
'SELECT * FROM maxdb;', error: OperationalError('no such table: maxdb')
2020-10-22 23:40:17,881 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: maxdb\n'
@
@
@
@
:$
2020-10-26 12:03:45,599 (60179/MainThread) lakecli.iam.scanner INFO - 6
columns found in tickit.tickit_public_event
2020-10-26 12:03:45,599 (60179/MainThread) lakecli.iam.scanner INFO - 8
columns found in tickit.tickit_public_listing
2020-10-26 12:03:45,599 (60179/MainThread) lakecli.iam.scanner INFO - 10
columns found in tickit.tickit_public_sales
2020-10-26 12:03:45,599 (60179/MainThread) lakecli.iam.scanner INFO - 18
columns found in tickit.tickit_public_users
2020-10-26 12:03:45,599 (60179/MainThread) lakecli.iam.scanner INFO - 5
columns found in tickit.tickit_public_venue
2020-10-26 12:03:45,619 (60179/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-26 12:03:45,620 (60179/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
2020-10-26 12:59:11,042 (63536/MainThread) lakecli.main INFO - Scanning
Lake Formation Permissions
2020-10-26 12:59:11,042 (63536/MainThread) lakecli.main INFO - Scanning
Lake Formation Permissions
2020-10-26 12:59:11,042 (63536/MainThread) lakecli.iam.scanner INFO -
Remove old sqlite database at /Users/yli/.lakecli/iamdb
2020-10-26 12:59:11,716 (63536/MainThread) lakecli.iam.scanner INFO - 0
table permissions found.
2020-10-26 12:59:11,716 (63536/MainThread) lakecli.iam.scanner INFO - 1
database permissions found.
2020-10-26 12:59:12,221 (63536/MainThread) lakecli.iam.scanner INFO - 8
databases found
2020-10-26 12:59:12,361 (63536/MainThread) lakecli.iam.scanner INFO - 0
tables found in default
2020-10-26 12:59:12,518 (63536/MainThread) lakecli.iam.scanner INFO - 1
tables found in flightdb
2020-10-26 12:59:12,518 (63536/MainThread) lakecli.iam.scanner INFO - 64
columns found in flightdb.flightscsv
2020-10-26 12:59:12,675 (63536/MainThread) lakecli.iam.scanner INFO - 1
tables found in maxdb
2020-10-26 12:59:12,675 (63536/MainThread) lakecli.iam.scanner INFO - 8
columns found in maxdb.customers
2020-10-26 12:59:12,818 (63536/MainThread) lakecli.iam.scanner INFO - 3
tables found in myfirstgluedb
2020-10-26 12:59:12,818 (63536/MainThread) lakecli.iam.scanner INFO - 5
columns found in myfirstgluedb.active
2020-10-26 12:59:12,819 (63536/MainThread) lakecli.iam.scanner INFO - 5
columns found in myfirstgluedb.citydata
2020-10-26 12:59:12,819 (63536/MainThread) lakecli.iam.scanner INFO - 5
columns found in myfirstgluedb.old
2020-10-26 12:59:12,956 (63536/MainThread) lakecli.iam.scanner INFO - 1
tables found in spectrumdb
2020-10-26 12:59:12,956 (63536/MainThread) lakecli.iam.scanner INFO - 10
columns found in spectrumdb.sales
2020-10-26 12:59:13,132 (63536/MainThread) lakecli.iam.scanner INFO - 1
tables found in testbucket
2020-10-26 12:59:13,133 (63536/MainThread) lakecli.iam.scanner INFO - 5
columns found in testbucket.maxwell_citydata_test
2020-10-26 12:59:13,264 (63536/MainThread) lakecli.iam.scanner INFO - 0
tables found in testdb
2020-10-26 12:59:13,422 (63536/MainThread) lakecli.iam.scanner INFO - 7
tables found in tickit
2020-10-26 12:59:13,422 (63536/MainThread) lakecli.iam.scanner INFO - 4
columns found in tickit.tickit_public_category
2020-10-26 12:59:13,422 (63536/MainThread) lakecli.iam.scanner INFO - 8
columns found in tickit.tickit_public_date
2020-10-26 12:59:13,423 (63536/MainThread) lakecli.iam.scanner INFO - 6
columns found in tickit.tickit_public_event
2020-10-26 12:59:13,423 (63536/MainThread) lakecli.iam.scanner INFO - 8
columns found in tickit.tickit_public_listing
2020-10-26 12:59:13,423 (63536/MainThread) lakecli.iam.scanner INFO - 10
columns found in tickit.tickit_public_sales
2020-10-26 12:59:13,423 (63536/MainThread) lakecli.iam.scanner INFO - 18
columns found in tickit.tickit_public_users
2020-10-26 12:59:13,423 (63536/MainThread) lakecli.iam.scanner INFO - 5
columns found in tickit.tickit_public_venue
2020-10-26 12:59:13,452 (63536/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-26 12:59:13,454 (63536/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
…On Mon, Oct 26, 2020 at 9:31 AM Rajat Venkatesh ***@***.***> wrote:
Can you paste the logs for the run with --scan ?
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
<#17 (comment)>, or
unsubscribe
<https://github.com/notifications/unsubscribe-auth/AHTW7AOB4VWWAEY7MGSW64LSMWB4VANCNFSM4S57TN3A>
.
|
|
now,
~/.lakecli ❯ lakecli --scan
\r:iamdb> select * from table_privileges;
0 rows in set
Time: 0.001s
\r:iamdb>
\r:iamdb> select * from database_privileges;
+----+-------------+-----------+--------------+-------+
| id | schema_name | principal | permission | grant |
+----+-------------+-----------+--------------+-------+
| 1 | default | user/yli2 | ALTER | 1 |
| 2 | default | user/yli2 | CREATE_TABLE | 1 |
| 3 | default | user/yli2 | DESCRIBE | 1 |
| 4 | default | user/yli2 | DROP | 1 |
+----+-------------+-----------+--------------+-------+
4 rows in set
Time: 0.015s
\r:iamdb> quit
…On Mon, Oct 26, 2020 at 1:00 PM Yingyou ***@***.***> wrote:
~/.lakecli ❯ vim app.log
2020-10-22 23:33:25,840 (38148/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:33:25,841 (38148/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,679 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_priviledges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_priviledges')
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:16,683 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_priviledges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - sql:
"SELECT * FROM table_privileges WHERE principal like 'yli%';", error:
OperationalError('no such table: table_privileges')
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:37:46,526 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: table_privileges\n'
2020-10-22 23:40:17,880 (38148/MainThread) lakecli.main ERROR - sql:
'SELECT * FROM maxdb;', error: OperationalError('no such table: maxdb')
2020-10-22 23:40:17,880 (38148/MainThread) lakecli.main ERROR - sql:
'SELECT * FROM maxdb;', error: OperationalError('no such table: maxdb')
2020-10-22 23:40:17,881 (38148/MainThread) lakecli.main ERROR - traceback:
'Traceback (most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 74, in run\n for result in special.execute(cur, sql):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/packages/special/main.py",
line 66, in execute\n raise
CommandNotFound\nlakecli.packages.special.main.CommandNotFound\n\nDuring
handling of the above exception, another exception occurred:\n\nTraceback
(most recent call last):\n File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/main.py",
line 331, in one_iteration\n for title, rows, headers, status in res:\n
File
"/Users/yli/opt/anaconda3/lib/python3.8/site-packages/lakecli/sqlexecute.py",
line 77, in run\n cur.execute(sql)\nsqlite3.OperationalError: no such
table: maxdb\n'
@
@
@
@
:$
2020-10-26 12:03:45,599 (60179/MainThread) lakecli.iam.scanner INFO - 6
columns found in tickit.tickit_public_event
2020-10-26 12:03:45,599 (60179/MainThread) lakecli.iam.scanner INFO - 8
columns found in tickit.tickit_public_listing
2020-10-26 12:03:45,599 (60179/MainThread) lakecli.iam.scanner INFO - 10
columns found in tickit.tickit_public_sales
2020-10-26 12:03:45,599 (60179/MainThread) lakecli.iam.scanner INFO - 18
columns found in tickit.tickit_public_users
2020-10-26 12:03:45,599 (60179/MainThread) lakecli.iam.scanner INFO - 5
columns found in tickit.tickit_public_venue
2020-10-26 12:03:45,619 (60179/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-26 12:03:45,620 (60179/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
2020-10-26 12:59:11,042 (63536/MainThread) lakecli.main INFO - Scanning
Lake Formation Permissions
2020-10-26 12:59:11,042 (63536/MainThread) lakecli.main INFO - Scanning
Lake Formation Permissions
2020-10-26 12:59:11,042 (63536/MainThread) lakecli.iam.scanner INFO -
Remove old sqlite database at /Users/yli/.lakecli/iamdb
2020-10-26 12:59:11,716 (63536/MainThread) lakecli.iam.scanner INFO - 0
table permissions found.
2020-10-26 12:59:11,716 (63536/MainThread) lakecli.iam.scanner INFO - 1
database permissions found.
2020-10-26 12:59:12,221 (63536/MainThread) lakecli.iam.scanner INFO - 8
databases found
2020-10-26 12:59:12,361 (63536/MainThread) lakecli.iam.scanner INFO - 0
tables found in default
2020-10-26 12:59:12,518 (63536/MainThread) lakecli.iam.scanner INFO - 1
tables found in flightdb
2020-10-26 12:59:12,518 (63536/MainThread) lakecli.iam.scanner INFO - 64
columns found in flightdb.flightscsv
2020-10-26 12:59:12,675 (63536/MainThread) lakecli.iam.scanner INFO - 1
tables found in maxdb
2020-10-26 12:59:12,675 (63536/MainThread) lakecli.iam.scanner INFO - 8
columns found in maxdb.customers
2020-10-26 12:59:12,818 (63536/MainThread) lakecli.iam.scanner INFO - 3
tables found in myfirstgluedb
2020-10-26 12:59:12,818 (63536/MainThread) lakecli.iam.scanner INFO - 5
columns found in myfirstgluedb.active
2020-10-26 12:59:12,819 (63536/MainThread) lakecli.iam.scanner INFO - 5
columns found in myfirstgluedb.citydata
2020-10-26 12:59:12,819 (63536/MainThread) lakecli.iam.scanner INFO - 5
columns found in myfirstgluedb.old
2020-10-26 12:59:12,956 (63536/MainThread) lakecli.iam.scanner INFO - 1
tables found in spectrumdb
2020-10-26 12:59:12,956 (63536/MainThread) lakecli.iam.scanner INFO - 10
columns found in spectrumdb.sales
2020-10-26 12:59:13,132 (63536/MainThread) lakecli.iam.scanner INFO - 1
tables found in testbucket
2020-10-26 12:59:13,133 (63536/MainThread) lakecli.iam.scanner INFO - 5
columns found in testbucket.maxwell_citydata_test
2020-10-26 12:59:13,264 (63536/MainThread) lakecli.iam.scanner INFO - 0
tables found in testdb
2020-10-26 12:59:13,422 (63536/MainThread) lakecli.iam.scanner INFO - 7
tables found in tickit
2020-10-26 12:59:13,422 (63536/MainThread) lakecli.iam.scanner INFO - 4
columns found in tickit.tickit_public_category
2020-10-26 12:59:13,422 (63536/MainThread) lakecli.iam.scanner INFO - 8
columns found in tickit.tickit_public_date
2020-10-26 12:59:13,423 (63536/MainThread) lakecli.iam.scanner INFO - 6
columns found in tickit.tickit_public_event
2020-10-26 12:59:13,423 (63536/MainThread) lakecli.iam.scanner INFO - 8
columns found in tickit.tickit_public_listing
2020-10-26 12:59:13,423 (63536/MainThread) lakecli.iam.scanner INFO - 10
columns found in tickit.tickit_public_sales
2020-10-26 12:59:13,423 (63536/MainThread) lakecli.iam.scanner INFO - 18
columns found in tickit.tickit_public_users
2020-10-26 12:59:13,423 (63536/MainThread) lakecli.iam.scanner INFO - 5
columns found in tickit.tickit_public_venue
2020-10-26 12:59:13,452 (63536/MainThread) lakecli.sqlexecute INFO -
Connect to /Users/yli/.lakecli/iamdb
2020-10-26 12:59:13,454 (63536/completion_refresh) lakecli.sqlexecute INFO
- Connect to /Users/yli/.lakecli/iamdb
On Mon, Oct 26, 2020 at 9:31 AM Rajat Venkatesh ***@***.***>
wrote:
> Can you paste the logs for the run with --scan ?
>
> —
> You are receiving this because you authored the thread.
> Reply to this email directly, view it on GitHub
> <#17 (comment)>, or
> unsubscribe
> <https://github.com/notifications/unsubscribe-auth/AHTW7AOB4VWWAEY7MGSW64LSMWB4VANCNFSM4S57TN3A>
> .
>
|
|
Great! Looks like progress. It is partially working ? Did you have to exit and restart the application ? As per logs, it did not find any table permissions but found database level permissions. Is this unexpected? Can you please check and confirm if any table level permissions are set in LakeFormation UI? Reference: https://docs.aws.amazon.com/lake-formation/latest/dg/granting-table-permissions.html |
|
it doesn't work well, and as you see, it cannot detect other databases
except default db. please advise how to get other dbs in? and I don't
see any tables right now
…On Mon, Oct 26, 2020 at 11:25 PM Rajat Venkatesh ***@***.***> wrote:
Great! Looks like it is working ? Did you have to exit and restart ?
—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub, or unsubscribe.
|
|
log file showed that dbs and tables were found but you cannot see them
when you query the two tables
…On Mon, Oct 26, 2020 at 11:47 PM Yingyou ***@***.***> wrote:
it doesn't work well, and as you see, it cannot detect other databases
except default db. please advise how to get other dbs in? and I don't
see any tables right now
On Mon, Oct 26, 2020 at 11:25 PM Rajat Venkatesh
***@***.***> wrote:
>
> Great! Looks like it is working ? Did you have to exit and restart ?
>
> —
> You are receiving this because you authored the thread.
> Reply to this email directly, view it on GitHub, or unsubscribe.
|
|
table_privileges and database_privileges only store the permissions. table_privileges is empty because no table permissions are set. If you set a permission using grant table ... or revoke table ..., then you will see entries. Looks like you want to also list databases and tables in glue catalog using SQL? Like 'select * from tables?' ? |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
\r:iamdb> SELECT * FROM database_privileges;
no such table: database_privileges
\r:iamdb> SELECT * FROM table_privileges;
no such table: table_privileges
\r:iamdb>
The text was updated successfully, but these errors were encountered: