tooptoop4 opened a new issue #9384: presto issues URL: https://github.com/apache/incubator-superset/issues/9384 using superset for first time on 0.35.2 release , found several oddities: 1. Schema on the left shows datatype of OTHER instead of varchar(40) log has 2020-03-26 00:13:10,188:INFO:root:Did not recognize type varchar(300) of column country_name 2020-03-26 00:13:10,188:INFO:root:Did not recognize type varchar(40) of column ccn 2. bad auto SQLs being sent (should say TABLE not VIEW) com.facebook.presto.sql.analyzer.SemanticException: line 1:1: Relation 'hive.sc.t2' is a table, not a view SHOW CREATE VIEW sc.t2 3. bad auto SQL being sent (does not filter on TIMESTAMP col properly) com.facebook.presto.sql.analyzer.SemanticException: line 83:21: '=' cannot be applied to timestamp, varchar(23) select a,b,c FROM "sc"."tb" WHERE "datestr" = '20190114' AND "filename" = 'Current_Book_Monthly_ASIA' AND "insert_time" = '2020-03-25 18:36:07.476' LIMIT 100 4. it seems to assume schema is 'default' instead of using actual schema com.facebook.presto.sql.analyzer.SemanticException: line 1:15: Table hive.default.current_book_monthly$partitions does not exist at com.facebook.presto.sql.analyzer.StatementAnalyzer$Visitor.visitTable(StatementAnalyzer.java:917) SELECT * FROM "current_book_monthly$partitions" ORDER BY datestr DESC, filename DESC, insert_time DESC LIMIT 1 5. upload csv Unable to upload CSV file "x.csv" to table "vvv" in database "presto". Error message: (builtins.ValueError) Protocol must be https when passing a password [SQL: SHOW COLUMNS FROM "x"."vvv"] 6. tick 'allow impersonation': (pyhive.exc.OperationalError) Unexpected status code 401 b'<html>\n<head>\n<meta http-equiv="Content-Type" content="text/html;charset=utf-8"/>\n<title>Error 401 Access Denied: Invalid credentials</title>\n</head>\n<body><h2>HTTP ERROR 401</h2>\n<p>Problem accessing /v1/statement. Reason:\n<pre> Access Denied: Invalid credentials</pre></p>\n</body>\n</html>\n' [SQL: SHOW SCHEMAS] (Background on this error at: http://sqlalche.me/e/e3q8) 7. /superset/welcome page has the infinite icon spinning forever 8. log has this error frequently 2020-03-26 00:13:14,836:WARNING:root:timeout can't be used in the current context 2020-03-26 00:13:14,836:ERROR:root:signal only works in main thread Traceback (most recent call last): File "/usr/lib/python3.6/dist-packages/superset/utils/core.py", line 593, in __enter__ signal.signal(signal.SIGALRM, self.handle_timeout) File "/usr/lib64/python3.6/signal.py", line 47, in signal handler = _signal.signal(_enum_to_int(signalnum), _enum_to_int(handler)) ValueError: signal only works in main thread
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
