You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "yujun2021 (via GitHub)" <gi...@apache.org> on 2024/12/29 05:14:23 UTC

[I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

yujun2021 opened a new issue, #31641:
URL: https://github.com/apache/superset/issues/31641

   ### Bug description
   
   1. when i query the connected odps database, the error is as follows
   ![image](https://github.com/user-attachments/assets/ec7ed8aa-b45c-460d-86b9-fd6fe74d23b6)
   
   2. The detailed error log is as follows
   ```md 
   Traceback (most recent call last):
     File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1484, in full_dispatch_request
       rv = self.dispatch_request()
     File "/usr/local/lib/python3.10/site-packages/flask/app.py", line 1469, in dispatch_request
       return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
     File "/usr/local/lib/python3.10/site-packages/flask_appbuilder/security/decorators.py", line 95, in wraps
       return f(self, *args, **kwargs)
     File "/app/superset/views/base_api.py", line 119, in wraps
       duration, response = time_function(f, self, *args, **kwargs)
     File "/app/superset/utils/core.py", line 1364, in time_function
       response = func(*args, **kwargs)
     File "/app/superset/views/base_api.py", line 91, in wraps
       return f(self, *args, **kwargs)
     File "/app/superset/utils/log.py", line 303, in wrapper
       value = f(*args, **kwargs)
     File "/app/superset/sqllab/api.py", line 409, in execute_sql_query
       command_result: CommandResult = command.run()
     File "/app/superset/utils/decorators.py", line 266, in wrapped
       return on_error(ex)
     File "/app/superset/utils/decorators.py", line 236, in on_error
       raise ex
     File "/app/superset/utils/decorators.py", line 259, in wrapped
       result = func(*args, **kwargs)
     File "/app/superset/commands/sql_lab/execute.py", line 105, in run
       status = self._run_sql_json_exec_from_scratch()
     File "/app/superset/commands/sql_lab/execute.py", line 158, in _run_sql_json_exec_from_scratch
       return self._sql_json_executor.execute(
     File "/app/superset/sqllab/sql_json_executer.py", line 111, in execute
       raise SupersetErrorsException(
   superset.exceptions.SupersetErrorsException: [SupersetError(message='odps error: ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given', error_type=, level=, extra={'engine_name': 'ODPS', 'issue_codes': [{'code': 1002, 'message': 'Issue 1002 - The database returned an unexpected error.'}]})]
   ```
   
   3. The relevant database and driver versions are as follows:
   ![image](https://github.com/user-attachments/assets/983370fc-1e81-48fd-94b2-0ff38409596c)
   
   
   
   
   
   
   ### Screenshots/recordings
   
   _No response_
   
   ### Superset version
   
   4.1.1
   
   ### Python version
   
   3.10
   
   ### Node version
   
   I don't know
   
   ### Browser
   
   Chrome
   
   ### Additional context
   
   _No response_
   
   ### Checklist
   
   - [X] I have searched Superset docs and Slack and didn't find a solution to my problem.
   - [X] I have searched the GitHub issue tracker and didn't find a similar bug report.
   - [X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.


-- 
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: notifications-unsubscribe@superset.apache.org.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2574412001

   > > > Should be resolved with PyODPS 0.12.2 release. See https://github.com/aliyun/aliyun-odps-python-sdk/releases/tag/v0.12.2 for details.
   > > 
   > > 
   > > 
   > > 1. When I uninstalled the old version 0.12.1.1 of pyodps and installed the new version 0.12.2, the same error was reported. The details are as follows
   > >    ![image](https://private-user-images.githubusercontent.com/79888193/400117323-46e76bf5-3320-4586-89ae-acf81577500c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTczMjMtNDZlNzZiZjUtMzMyMC00NTg2LTg5YWUtYWNmODE1Nzc1MDBjLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTVmNzc2NjEzNTczZTk5ODcxOGI0MTdkNjA0NmU5NjJkMzczZTc0Yjk2OTRmYzhjNWE5ZWQyMTlkMTM1NTg2YzMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.h749N4XHCZ_uv6WcdKVf6Qu_NSmBIWp0LOi0suo7r6g)
   > > 2. I suspect there is something wrong with the way the connection is made, or pyodps doesn't really fix the error.
   > >    ![image](https://private-user-images.githubusercontent.com/79888193/400117430-a0ef5aa8-59b5-41e2-a554-78d959cfd807.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTc0MzAtYTBlZjVhYTgtNTliNS00MWUyLWE1NTQtNzhkOTU5Y2ZkODA3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTIxNzRmN2U1NzBjNzg5NzM0ZDFiMWEzNmQ3YjYxZmJiMWYzNzVkZjlmYmZiZmQ3NzJhYWM4MmRlOTIzYTY5NWYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0._D--wmDoQfnCyc4iMKJnAs4Qf_hcFFVPLA6XFmqUA_o)
   > 
   > <img alt="image" width="1788" src="https://private-user-images.githubusercontent.com/8284922/400602641-50ad4dc5-0e48-44cd-8ce5-8516809f5381.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMjY5MTgsIm5iZiI6MTczNjIyNjYxOCwicGF0aCI6Ii84Mjg0OTIyLzQwMDYwMjY0MS01MGFkNGRjNS0wZTQ4LTQ0Y2QtOGNlNS04NTE2ODA5ZjUzODEucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI1MDEwNyUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNTAxMDdUMDUxMDE4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9M2FkNzU3ZGU3MDUwYjZkNmM2NDY1ZmFmYzBmYjAzY2YxNDgxMWRjNmZiYjcwMzE5NWZmYjVhZjljMmI4OWI4NiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.gouGY2DnioE5ho_7BSGca8tfj6eGClb8G1ktdixTl-g"> Works for me. Given the error message it is quite possible that the correct version is not properly installed for superset as the function signature is already correct for the lat
 est version of superset.
   
   I'm curious how you deployed the superset service. I installed it through k8s helm chart, and then pip install pyodps==0.12.2; my superset version is 4.1.1


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "wjsi (via GitHub)" <gi...@apache.org>.
wjsi commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2586231115

   > > ... conversation omitted ...
   > 
   > 1)The above problem has been solved!thank you very much! 2)A new problem has arisen. Although I can query the data of the odps database, I cannot obtain the metadata of the database table, such as column and field information. the following situation ![image](https://private-user-images.githubusercontent.com/79888193/402242025-2b2d193f-9d78-4c66-9315-ae7fc367cef2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzY3NDc3NjUsIm5iZiI6MTczNjc0NzQ2NSwicGF0aCI6Ii83OTg4ODE5My80MDIyNDIwMjUtMmIyZDE5M2YtOWQ3OC00YzY2LTkzMTUtYWU3ZmMzNjdjZWYyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTEzVDA1NTEwNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTA1NmRmZjMyNjA2MTE1MjEyZmFhNWYyYjNjM2IxMmM0NjA4YjgwNmZlOTc2NDM3YzRlN2NhMTM1OThjM2QwYzQmWC1BbXotU2lnbmVkSGVhZGVycz
 1ob3N0In0.JCZ51Sz0xDMOQyD8Zw25_km3Qt9Z6AlLgT_Toj1G2_o)
   > 
   > ![image](https://private-user-images.githubusercontent.com/79888193/402241898-c7654ade-9d64-4f6a-a5ec-b901a326f740.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzY3NDc3NjUsIm5iZiI6MTczNjc0NzQ2NSwicGF0aCI6Ii83OTg4ODE5My80MDIyNDE4OTgtYzc2NTRhZGUtOWQ2NC00ZjZhLWE1ZWMtYjkwMWEzMjZmNzQwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTEzVDA1NTEwNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTI0NGMwY2E5OGEwOWMxYWRiZTc0MmY3NjBlZmY5YTk2MmUxNDRkNDllMDRmYWI5ODJmZGY3MTQyNDkxYjQ3OWEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.JQnpBr12KrHVcXX9PTVlVtVNVJ0eHftwyX-qkQbh3no)
   
   It cannot be resolved currently as Superset points to the base db engine spec instead of the customized one when running SQL statements to obtain database meta. It might be resolved when MaxCompute is added to dialects of sqlglot but this absolutely takes time.


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2598687828

   > > > > > ... conversation omitted ...
   > > > > 
   > > > > 
   > > > > 1)The above problem has been solved!thank you very much! 2)A new problem has arisen. Although I can query the data of the odps database, I cannot obtain the metadata of the database table, such as column and field information. the following situation ![image](https://private-user-images.githubusercontent.com/79888193/402242025-2b2d193f-9d78-4c66-9315-ae7fc367cef2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzY3NDc3NjUsIm5iZiI6MTczNjc0NzQ2NSwicGF0aCI6Ii83OTg4ODE5My80MDIyNDIwMjUtMmIyZDE5M2YtOWQ3OC00YzY2LTkzMTUtYWU3ZmMzNjdjZWYyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTEzVDA1NTEwNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTA1NmRmZjMyNjA2MTE1MjEyZmFhNWYyYjNjM2IxMmM0NjA4YjgwNmZlOTc2NDM3YzRlN2NhMTM1OThjM2QwYzQmWC1BbXotU2lnbmVkSGVh
 ZGVycz1ob3N0In0.JCZ51Sz0xDMOQyD8Zw25_km3Qt9Z6AlLgT_Toj1G2_o)
   > > > > ![image](https://private-user-images.githubusercontent.com/79888193/402241898-c7654ade-9d64-4f6a-a5ec-b901a326f740.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzY3NDc3NjUsIm5iZiI6MTczNjc0NzQ2NSwicGF0aCI6Ii83OTg4ODE5My80MDIyNDE4OTgtYzc2NTRhZGUtOWQ2NC00ZjZhLWE1ZWMtYjkwMWEzMjZmNzQwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTEzVDA1NTEwNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTI0NGMwY2E5OGEwOWMxYWRiZTc0MmY3NjBlZmY5YTk2MmUxNDRkNDllMDRmYWI5ODJmZGY3MTQyNDkxYjQ3OWEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.JQnpBr12KrHVcXX9PTVlVtVNVJ0eHftwyX-qkQbh3no)
   > > > 
   > > > 
   > > > It cannot be resolved currently as Superset points to the base db engine spec instead of the customized one when running SQL statements to obtain database meta. It might be resolved when MaxCompute is added to dialects of sqlglot but this absolutely takes time.
   > > 
   > > 
   > > It would be great if these problems could be solved, do we have any plans to solve these problems?
   > 
   > It takes time and will not be resolved right now.
   1) When I was about to save the data set, I found that I couldn't get an error.
   ![Image](https://github.com/user-attachments/assets/019fdd9d-e574-46ad-a6bb-e7b647a9c1a2)  
   
   2)Loading the data set will also report an error 
   ![Image](https://github.com/user-attachments/assets/e12e0221-1ad5-4273-a6ca-912439301445)


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2957292518

   This has been silent for quite a while, and I'm not quite sure why it was reopened. Can anyone recap the bug to fix? 


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2566583190

   > @dosu please assign this issue to me
   
   Is there any solution?
   


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2564616447

   <!-- Greeting -->
   @yujun2021 Hello there! I'm Dosu, a bot here to help you with bug fixes, questions, and becoming a contributor. Let's tackle this issue together while we wait for a human maintainer.
   
   <!-- Answer -->
   The error you're encountering indicates that the `ODPSEngineSpec.execute()` method is being called with more arguments than it expects. This typically suggests a mismatch between the method's implementation and how it's being invoked.
   
   To resolve this issue, you can try the following steps:
   
   1. **Check the Method Signature**: Verify the current implementation of the `ODPSEngineSpec.execute()` method in your Superset codebase. Ensure that the number of arguments being passed matches the method's signature.
   
   2. **Review Recent Changes**: If there have been recent updates to the Superset codebase or the ODPS-related packages (`odps` or `pyodps`), check if any changes might have affected the method signature or its usage.
   
   3. **Compatibility**: Ensure that the versions of Superset, `odps`, and `pyodps` you are using are compatible. Sometimes, version mismatches can lead to such issues.
   
   4. **Custom Modifications**: If there are any custom modifications or extensions in your Superset setup, review them to ensure they align with the expected method signatures.
   
   If these steps do not resolve the issue, you may need to look into the specific implementation details of the `ODPSEngineSpec` class and how it interacts with the rest of the Superset codebase.
   
   
   <!-- Dosu Comment Footer -->
   *To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
   
   ---
   <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/ad7b8125-3fbe-4527-b85f-736124481ebc?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/ad7b8125-3fbe-4527-b85f-736124481ebc?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/ad7b8125-3fbe-4527-b85f-736124481ebc?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/ad7b8125-3fbe-4527-b85f-736124481ebc?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/ad7b8125-3fbe-4527-b85f-736124481ebc?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/ad7b8125-3fbe-4527-b85f-736124481ebc?feedback_type=other)</sup>
   


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 closed issue #31641:  When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given
URL: https://github.com/apache/superset/issues/31641


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "zhongsheng-chen (via GitHub)" <gi...@apache.org>.
zhongsheng-chen commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2703414604

   Hi, I suffer the same issue, Anyone can help me out, I will appreciated.  Here are versions of some packages installed, pyodps=0.12.2(the latest version) and apache-superset=4.1.1. ODPS is deployed inner my company. The version of ODPS  did not support schema, but superset UI set schema for ODPS to 'Default'. I can not choose schema for another.
   


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2585160904

   > > > > > Should be resolved with PyODPS 0.12.2 release. See https://github.com/aliyun/aliyun-odps-python-sdk/releases/tag/v0.12.2 for details.
   > > > > 
   > > > > 
   > > > > 
   > > > > 1. When I uninstalled the old version 0.12.1.1 of pyodps and installed the new version 0.12.2, the same error was reported. The details are as follows
   > > > >    ![image](https://private-user-images.githubusercontent.com/79888193/400117323-46e76bf5-3320-4586-89ae-acf81577500c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTczMjMtNDZlNzZiZjUtMzMyMC00NTg2LTg5YWUtYWNmODE1Nzc1MDBjLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTVmNzc2NjEzNTczZTk5ODcxOGI0MTdkNjA0NmU5NjJkMzczZTc0Yjk2OTRmYzhjNWE5ZWQyMTlkMTM1NTg2YzMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.h749N4XHCZ_uv6WcdKVf6Qu_NSmBIWp0LOi0suo7r6g)
   > > > > 2. I suspect there is something wrong with the way the connection is made, or pyodps doesn't really fix the error.
   > > > >    ![image](https://private-user-images.githubusercontent.com/79888193/400117430-a0ef5aa8-59b5-41e2-a554-78d959cfd807.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTc0MzAtYTBlZjVhYTgtNTliNS00MWUyLWE1NTQtNzhkOTU5Y2ZkODA3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTIxNzRmN2U1NzBjNzg5NzM0ZDFiMWEzNmQ3YjYxZmJiMWYzNzVkZjlmYmZiZmQ3NzJhYWM4MmRlOTIzYTY5NWYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0._D--wmDoQfnCyc4iMKJnAs4Qf_hcFFVPLA6XFmqUA_o)
   > > > 
   > > > 
   > > > <img alt="image" width="1788" src="https://private-user-images.githubusercontent.com/8284922/400602641-50ad4dc5-0e48-44cd-8ce5-8516809f5381.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMjY5MTgsIm5iZiI6MTczNjIyNjYxOCwicGF0aCI6Ii84Mjg0OTIyLzQwMDYwMjY0MS01MGFkNGRjNS0wZTQ4LTQ0Y2QtOGNlNS04NTE2ODA5ZjUzODEucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI1MDEwNyUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNTAxMDdUMDUxMDE4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9M2FkNzU3ZGU3MDUwYjZkNmM2NDY1ZmFmYzBmYjAzY2YxNDgxMWRjNmZiYjcwMzE5NWZmYjVhZjljMmI4OWI4NiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.gouGY2DnioE5ho_7BSGca8tfj6eGClb8G1ktdixTl-g"> Works for me. Given the error message it is quite possible that the correct version is not properly installed for superset as the function signature is already correct for the
  latest version of superset.
   > > 
   > > 
   > > I'm curious how you deployed the superset service. I installed it through k8s helm chart, and then pip install pyodps==0.12.2; my superset version is 4.1.1
   > 
   > Installed with pip inside a virtualenv on host without any containers.
   
   1)The above problem has been solved!thank you very much!
   2)A new problem has arisen. Although I can query the data of the odps database, I cannot obtain the metadata of the database table, such as column and field information. the following situation 
   ![image](https://github.com/user-attachments/assets/2b2d193f-9d78-4c66-9315-ae7fc367cef2)
   
   ![image](https://github.com/user-attachments/assets/c7654ade-9d64-4f6a-a5ec-b901a326f740)
   
   
   


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "wjsi (via GitHub)" <gi...@apache.org>.
wjsi commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2568625595

   Should be resolved with PyODPS 0.12.2 release. https://github.com/aliyun/aliyun-odps-python-sdk/releases/tag/v0.12.2


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2570131574

   > Should be resolved with PyODPS 0.12.2 release. See https://github.com/aliyun/aliyun-odps-python-sdk/releases/tag/v0.12.2 for details.
   
   
   1) When I uninstalled the old version 0.12.1.1 of pyodps and installed the new version 0.12.2, the same error was reported. The details are as follows
   ![image](https://github.com/user-attachments/assets/46e76bf5-3320-4586-89ae-acf81577500c)
   
   
   2) I suspect there is something wrong with the way the connection is made, or pyodps doesn't really fix the error.
   ![image](https://github.com/user-attachments/assets/a0ef5aa8-59b5-41e2-a554-78d959cfd807)
   
   
   


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2585158502

   > > > > > Should be resolved with PyODPS 0.12.2 release. See https://github.com/aliyun/aliyun-odps-python-sdk/releases/tag/v0.12.2 for details.
   > > > > 
   > > > > 
   > > > > 
   > > > > 1. When I uninstalled the old version 0.12.1.1 of pyodps and installed the new version 0.12.2, the same error was reported. The details are as follows
   > > > >    ![image](https://private-user-images.githubusercontent.com/79888193/400117323-46e76bf5-3320-4586-89ae-acf81577500c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTczMjMtNDZlNzZiZjUtMzMyMC00NTg2LTg5YWUtYWNmODE1Nzc1MDBjLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTVmNzc2NjEzNTczZTk5ODcxOGI0MTdkNjA0NmU5NjJkMzczZTc0Yjk2OTRmYzhjNWE5ZWQyMTlkMTM1NTg2YzMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.h749N4XHCZ_uv6WcdKVf6Qu_NSmBIWp0LOi0suo7r6g)
   > > > > 2. I suspect there is something wrong with the way the connection is made, or pyodps doesn't really fix the error.
   > > > >    ![image](https://private-user-images.githubusercontent.com/79888193/400117430-a0ef5aa8-59b5-41e2-a554-78d959cfd807.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTc0MzAtYTBlZjVhYTgtNTliNS00MWUyLWE1NTQtNzhkOTU5Y2ZkODA3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTIxNzRmN2U1NzBjNzg5NzM0ZDFiMWEzNmQ3YjYxZmJiMWYzNzVkZjlmYmZiZmQ3NzJhYWM4MmRlOTIzYTY5NWYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0._D--wmDoQfnCyc4iMKJnAs4Qf_hcFFVPLA6XFmqUA_o)
   > > > 
   > > > 
   > > > <img alt="image" width="1788" src="https://private-user-images.githubusercontent.com/8284922/400602641-50ad4dc5-0e48-44cd-8ce5-8516809f5381.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMjY5MTgsIm5iZiI6MTczNjIyNjYxOCwicGF0aCI6Ii84Mjg0OTIyLzQwMDYwMjY0MS01MGFkNGRjNS0wZTQ4LTQ0Y2QtOGNlNS04NTE2ODA5ZjUzODEucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI1MDEwNyUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNTAxMDdUMDUxMDE4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9M2FkNzU3ZGU3MDUwYjZkNmM2NDY1ZmFmYzBmYjAzY2YxNDgxMWRjNmZiYjcwMzE5NWZmYjVhZjljMmI4OWI4NiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.gouGY2DnioE5ho_7BSGca8tfj6eGClb8G1ktdixTl-g"> Works for me. Given the error message it is quite possible that the correct version is not properly installed for superset as the function signature is already correct for the
  latest version of superset.
   > > 
   > > 
   > > I'm curious how you deployed the superset service. I installed it through k8s helm chart, and then pip install pyodps==0.12.2; my superset version is 4.1.1
   > 
   > Installed with pip inside a virtualenv on host without any containers.
   
   


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2599585348

   > > > > > ... conversation omitted ...
   > > > > 
   > > > > 
   > > > > 1)The above problem has been solved!thank you very much! 2)A new problem has arisen. Although I can query the data of the odps database, I cannot obtain the metadata of the database table, such as column and field information. the following situation ![image](https://private-user-images.githubusercontent.com/79888193/402242025-2b2d193f-9d78-4c66-9315-ae7fc367cef2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzY3NDc3NjUsIm5iZiI6MTczNjc0NzQ2NSwicGF0aCI6Ii83OTg4ODE5My80MDIyNDIwMjUtMmIyZDE5M2YtOWQ3OC00YzY2LTkzMTUtYWU3ZmMzNjdjZWYyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTEzVDA1NTEwNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTA1NmRmZjMyNjA2MTE1MjEyZmFhNWYyYjNjM2IxMmM0NjA4YjgwNmZlOTc2NDM3YzRlN2NhMTM1OThjM2QwYzQmWC1BbXotU2lnbmVkSGVh
 ZGVycz1ob3N0In0.JCZ51Sz0xDMOQyD8Zw25_km3Qt9Z6AlLgT_Toj1G2_o)
   > > > > ![image](https://private-user-images.githubusercontent.com/79888193/402241898-c7654ade-9d64-4f6a-a5ec-b901a326f740.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzY3NDc3NjUsIm5iZiI6MTczNjc0NzQ2NSwicGF0aCI6Ii83OTg4ODE5My80MDIyNDE4OTgtYzc2NTRhZGUtOWQ2NC00ZjZhLWE1ZWMtYjkwMWEzMjZmNzQwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTEzVDA1NTEwNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTI0NGMwY2E5OGEwOWMxYWRiZTc0MmY3NjBlZmY5YTk2MmUxNDRkNDllMDRmYWI5ODJmZGY3MTQyNDkxYjQ3OWEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.JQnpBr12KrHVcXX9PTVlVtVNVJ0eHftwyX-qkQbh3no)
   > > > 
   > > > 
   > > > It cannot be resolved currently as Superset points to the base db engine spec instead of the customized one when running SQL statements to obtain database meta. It might be resolved when MaxCompute is added to dialects of sqlglot but this absolutely takes time.
   > > 
   > > 
   > > It would be great if these problems could be solved, do we have any plans to solve these problems?
   > 
   > It takes time and will not be resolved right now.
   
   
   
   I encountered two problems when using superset to connect to the odps database
   1) The odps data set cannot be created successfully.
   
   ![Image](https://github.com/user-attachments/assets/26906bb4-8600-4f35-8cdb-6f5f286d365e)
   
   
   2) odps metadata information and column names cannot be displayed
   ![Image](https://github.com/user-attachments/assets/0a08a682-d773-43e5-8fe1-83c62e107c49)
   I hope as follows
   ![Image](https://github.com/user-attachments/assets/206144cd-e536-4410-a658-3394872f1c9a)
   
   
   3)My odps version is v0.12.2, superset version 4.1.1. I would be very grateful if there is a plan to correct these problems recently.
   
   
   


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2571506533

   
   Anyone can help on this issue?
   
   


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2586333616

   > > > ... conversation omitted ...
   > > 
   > > 
   > > 1)The above problem has been solved!thank you very much! 2)A new problem has arisen. Although I can query the data of the odps database, I cannot obtain the metadata of the database table, such as column and field information. the following situation ![image](https://private-user-images.githubusercontent.com/79888193/402242025-2b2d193f-9d78-4c66-9315-ae7fc367cef2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzY3NDc3NjUsIm5iZiI6MTczNjc0NzQ2NSwicGF0aCI6Ii83OTg4ODE5My80MDIyNDIwMjUtMmIyZDE5M2YtOWQ3OC00YzY2LTkzMTUtYWU3ZmMzNjdjZWYyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTEzVDA1NTEwNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTA1NmRmZjMyNjA2MTE1MjEyZmFhNWYyYjNjM2IxMmM0NjA4YjgwNmZlOTc2NDM3YzRlN2NhMTM1OThjM2QwYzQmWC1BbXotU2lnbmVkSGVhZGVy
 cz1ob3N0In0.JCZ51Sz0xDMOQyD8Zw25_km3Qt9Z6AlLgT_Toj1G2_o)
   > > ![image](https://private-user-images.githubusercontent.com/79888193/402241898-c7654ade-9d64-4f6a-a5ec-b901a326f740.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzY3NDc3NjUsIm5iZiI6MTczNjc0NzQ2NSwicGF0aCI6Ii83OTg4ODE5My80MDIyNDE4OTgtYzc2NTRhZGUtOWQ2NC00ZjZhLWE1ZWMtYjkwMWEzMjZmNzQwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTEzVDA1NTEwNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTI0NGMwY2E5OGEwOWMxYWRiZTc0MmY3NjBlZmY5YTk2MmUxNDRkNDllMDRmYWI5ODJmZGY3MTQyNDkxYjQ3OWEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.JQnpBr12KrHVcXX9PTVlVtVNVJ0eHftwyX-qkQbh3no)
   > 
   > It cannot be resolved currently as Superset points to the base db engine spec instead of the customized one when running SQL statements to obtain database meta. It might be resolved when MaxCompute is added to dialects of sqlglot but this absolutely takes time.
   
   It would be great if these problems could be solved, do we have any plans to solve these problems?


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2599725962

   2025-01-18 13:51:14,169:ERROR:flask_appbuilder.api:Error parsing near '`' at line 2:14
   Traceback (most recent call last):
     File "/app/superset/sql/parse.py", line 256, in _parse
       return sqlglot.parse(script, dialect=dialect)
     File "/usr/local/lib/python3.10/site-packages/sqlglot/__init__.py", line 102, in parse
       return Dialect.get_or_raise(read or dialect).parse(sql, **opts)
     File "/usr/local/lib/python3.10/site-packages/sqlglot/dialects/dialect.py", line 919, in parse
       return self.parser(**opts).parse(self.tokenize(sql), sql)
     File "/usr/local/lib/python3.10/site-packages/sqlglot/parser.py", line 1395, in parse
       return self._parse(
     File "/usr/local/lib/python3.10/site-packages/sqlglot/parser.py", line 1467, in _parse
       self.raise_error("Invalid expression / Unexpected token")
     File "/usr/local/lib/python3.10/site-packages/sqlglot/parser.py", line 1508, in raise_error
       raise error
   sqlglot.errors.ParseError: Invalid expression / Unexpected token. Line 2, Col: 14.
     SELECT * 
   FROM `default`.`播放action`
    LIMIT 100
   
   The above exception was the direct cause of the following exception:
   
   Traceback (most recent call last):
     File "/usr/local/lib/python3.10/site-packages/flask_appbuilder/api/__init__.py", line 111, in wraps
       return f(self, *args, **kwargs)
     File "/app/superset/views/base_api.py", line 119, in wraps
       duration, response = time_function(f, self, *args, **kwargs)
     File "/app/superset/utils/core.py", line 1364, in time_function
       response = func(*args, **kwargs)
     File "/app/superset/utils/log.py", line 303, in wrapper
       value = f(*args, **kwargs)
     File "/app/superset/views/base_api.py", line 91, in wraps
       return f(self, *args, **kwargs)
     File "/app/superset/datasets/api.py", line 338, in post
       return self.response(201, id=new_model.id, result=item, data=new_model.data)
     File "/app/superset/connectors/sqla/models.py", line 1416, in data
       data_ = super().data
     File "/app/superset/connectors/sqla/models.py", line 404, in data
       "select_star": self.select_star,
     File "/app/superset/connectors/sqla/models.py", line 1395, in select_star
       return self.database.select_star(
     File "/app/superset/models/core.py", line 719, in select_star
       return self.db_engine_spec.select_star(
     File "/app/superset/db_engine_specs/base.py", line 1689, in select_star
       sql = SQLScript(sql, engine=cls.engine).format()
     File "/app/superset/sql/parse.py", line 611, in __init__
       self.statements = statement_class.split_script(script, engine)
     File "/app/superset/sql/parse.py", line 316, in split_script
       ast = cls._parse(remainder, engine)[0]
     File "/app/superset/sql/parse.py", line 259, in _parse
       raise SupersetParseError(
   superset.exceptions.SupersetParseError: Error parsing near '`' at line 2:14
   


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2708671731

   > Hi, I suffer the same issue, Anyone can help me out, I will appreciated. Here are versions of some packages installed, pyodps=0.12.2(the latest version) and apache-superset=4.1.1. ODPS is deployed inner my company. The version of ODPS did not support schema, but superset UI set schema for ODPS to 'Default'. I can not choose schema for another.
   
   You should add the following setting to the connection url 
   &project_as_schema=true


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "wjsi (via GitHub)" <gi...@apache.org>.
wjsi commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2574221354

   > > Should be resolved with PyODPS 0.12.2 release. See https://github.com/aliyun/aliyun-odps-python-sdk/releases/tag/v0.12.2 for details.
   > 
   > 1. When I uninstalled the old version 0.12.1.1 of pyodps and installed the new version 0.12.2, the same error was reported. The details are as follows
   >    ![image](https://private-user-images.githubusercontent.com/79888193/400117323-46e76bf5-3320-4586-89ae-acf81577500c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTczMjMtNDZlNzZiZjUtMzMyMC00NTg2LTg5YWUtYWNmODE1Nzc1MDBjLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTVmNzc2NjEzNTczZTk5ODcxOGI0MTdkNjA0NmU5NjJkMzczZTc0Yjk2OTRmYzhjNWE5ZWQyMTlkMTM1NTg2YzMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.h749N4XHCZ_uv6WcdKVf6Qu_NSmBIWp0LOi0suo7r6g)
   > 2. I suspect there is something wrong with the way the connection is made, or pyodps doesn't really fix the error.
   >    ![image](https://private-user-images.githubusercontent.com/79888193/400117430-a0ef5aa8-59b5-41e2-a554-78d959cfd807.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTc0MzAtYTBlZjVhYTgtNTliNS00MWUyLWE1NTQtNzhkOTU5Y2ZkODA3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTIxNzRmN2U1NzBjNzg5NzM0ZDFiMWEzNmQ3YjYxZmJiMWYzNzVkZjlmYmZiZmQ3NzJhYWM4MmRlOTIzYTY5NWYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0._D--wmDoQfnCyc4iMKJnAs4Qf_hcFFVPLA6XFmqUA_o)
   
   <img width="1788" alt="image" src="https://github.com/user-attachments/assets/50ad4dc5-0e48-44cd-8ce5-8516809f5381" />
   Works for me. Given the error message it is quite possible that the correct version is not properly installed for superset as the function signature is already correct for the latest version of superset.


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "dosubot[bot] (via GitHub)" <gi...@apache.org>.
dosubot[bot] commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2566583752

   <!-- Answer -->
   Could you provide more details about any recent changes or updates made to your Superset setup or the ODPS-related packages? Additionally, are there any custom modifications in your Superset environment that might affect the `ODPSEngineSpec.execute()` method? This information could help in identifying the root cause of the issue.
   
   
   <!-- Dosu Comment Footer -->
   *To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
   
   ---
   <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/bf43f950-100f-4b0e-95d1-5b61478a9dcc?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/bf43f950-100f-4b0e-95d1-5b61478a9dcc?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/bf43f950-100f-4b0e-95d1-5b61478a9dcc?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/bf43f950-100f-4b0e-95d1-5b61478a9dcc?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/bf43f950-100f-4b0e-95d1-5b61478a9dcc?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/bf43f950-100f-4b0e-95d1-5b61478a9dcc?feedback_type=other)</sup>
   


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 closed issue #31641:  When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given
URL: https://github.com/apache/superset/issues/31641


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-4035373500

   This issue was reopened but the specific bug to fix is unclear — @rusackas asked for a recap in June 2025 with no response. The `ODPSEngineSpec.execute()` signature mismatch appears to be a third-party driver compatibility issue rather than a core Superset bug. If this is still occurring on a current release, please provide a clear description of the remaining bug and a stack trace. Closing due to inactivity.


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #31641:  When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given
URL: https://github.com/apache/superset/issues/31641


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "AasmitPadea (via GitHub)" <gi...@apache.org>.
AasmitPadea commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2565662640

   @dosu please assign this issue to me
   


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 closed issue #31641:  When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given
URL: https://github.com/apache/superset/issues/31641


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 closed issue #31641:  When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given
URL: https://github.com/apache/superset/issues/31641


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "wjsi (via GitHub)" <gi...@apache.org>.
wjsi commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2597263300

   > > > > ... conversation omitted ...
   > > > 
   > > > 
   > > > 1)The above problem has been solved!thank you very much! 2)A new problem has arisen. Although I can query the data of the odps database, I cannot obtain the metadata of the database table, such as column and field information. the following situation ![image](https://private-user-images.githubusercontent.com/79888193/402242025-2b2d193f-9d78-4c66-9315-ae7fc367cef2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzY3NDc3NjUsIm5iZiI6MTczNjc0NzQ2NSwicGF0aCI6Ii83OTg4ODE5My80MDIyNDIwMjUtMmIyZDE5M2YtOWQ3OC00YzY2LTkzMTUtYWU3ZmMzNjdjZWYyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTEzVDA1NTEwNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTA1NmRmZjMyNjA2MTE1MjEyZmFhNWYyYjNjM2IxMmM0NjA4YjgwNmZlOTc2NDM3YzRlN2NhMTM1OThjM2QwYzQmWC1BbXotU2lnbmVkSGVhZG
 Vycz1ob3N0In0.JCZ51Sz0xDMOQyD8Zw25_km3Qt9Z6AlLgT_Toj1G2_o)
   > > > ![image](https://private-user-images.githubusercontent.com/79888193/402241898-c7654ade-9d64-4f6a-a5ec-b901a326f740.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzY3NDc3NjUsIm5iZiI6MTczNjc0NzQ2NSwicGF0aCI6Ii83OTg4ODE5My80MDIyNDE4OTgtYzc2NTRhZGUtOWQ2NC00ZjZhLWE1ZWMtYjkwMWEzMjZmNzQwLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMTMlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTEzVDA1NTEwNVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTI0NGMwY2E5OGEwOWMxYWRiZTc0MmY3NjBlZmY5YTk2MmUxNDRkNDllMDRmYWI5ODJmZGY3MTQyNDkxYjQ3OWEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.JQnpBr12KrHVcXX9PTVlVtVNVJ0eHftwyX-qkQbh3no)
   > > 
   > > 
   > > It cannot be resolved currently as Superset points to the base db engine spec instead of the customized one when running SQL statements to obtain database meta. It might be resolved when MaxCompute is added to dialects of sqlglot but this absolutely takes time.
   > 
   > It would be great if these problems could be solved, do we have any plans to solve these problems?
   
   It takes time and will not be resolved right now.


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "yujun2021 (via GitHub)" <gi...@apache.org>.
yujun2021 commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2574411182

   > > > Should be resolved with PyODPS 0.12.2 release. See https://github.com/aliyun/aliyun-odps-python-sdk/releases/tag/v0.12.2 for details.
   > > 
   > > 
   > > 
   > > 1. When I uninstalled the old version 0.12.1.1 of pyodps and installed the new version 0.12.2, the same error was reported. The details are as follows
   > >    ![image](https://private-user-images.githubusercontent.com/79888193/400117323-46e76bf5-3320-4586-89ae-acf81577500c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTczMjMtNDZlNzZiZjUtMzMyMC00NTg2LTg5YWUtYWNmODE1Nzc1MDBjLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTVmNzc2NjEzNTczZTk5ODcxOGI0MTdkNjA0NmU5NjJkMzczZTc0Yjk2OTRmYzhjNWE5ZWQyMTlkMTM1NTg2YzMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.h749N4XHCZ_uv6WcdKVf6Qu_NSmBIWp0LOi0suo7r6g)
   > > 2. I suspect there is something wrong with the way the connection is made, or pyodps doesn't really fix the error.
   > >    ![image](https://private-user-images.githubusercontent.com/79888193/400117430-a0ef5aa8-59b5-41e2-a554-78d959cfd807.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTc0MzAtYTBlZjVhYTgtNTliNS00MWUyLWE1NTQtNzhkOTU5Y2ZkODA3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTIxNzRmN2U1NzBjNzg5NzM0ZDFiMWEzNmQ3YjYxZmJiMWYzNzVkZjlmYmZiZmQ3NzJhYWM4MmRlOTIzYTY5NWYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0._D--wmDoQfnCyc4iMKJnAs4Qf_hcFFVPLA6XFmqUA_o)
   > 
   > <img alt="image" width="1788" src="https://private-user-images.githubusercontent.com/8284922/400602641-50ad4dc5-0e48-44cd-8ce5-8516809f5381.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMjY5MTgsIm5iZiI6MTczNjIyNjYxOCwicGF0aCI6Ii84Mjg0OTIyLzQwMDYwMjY0MS01MGFkNGRjNS0wZTQ4LTQ0Y2QtOGNlNS04NTE2ODA5ZjUzODEucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI1MDEwNyUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNTAxMDdUMDUxMDE4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9M2FkNzU3ZGU3MDUwYjZkNmM2NDY1ZmFmYzBmYjAzY2YxNDgxMWRjNmZiYjcwMzE5NWZmYjVhZjljMmI4OWI4NiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.gouGY2DnioE5ho_7BSGca8tfj6eGClb8G1ktdixTl-g"> Works for me. Given the error message it is quite possible that the correct version is not properly installed for superset as the function signature is already correct for the lat
 est version of superset.
   
   
   I'm curious how you deployed the superset service. I installed it through k8s helm chart, and then pip install pyodps==0.12.2; my superset version is 4.1.1


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Re: [I] When I use superset to query the connected odps database, the error ODPSEngineSpec.execute() takes 3 positional arguments but 4 were given [superset]

Posted by "wjsi (via GitHub)" <gi...@apache.org>.
wjsi commented on issue #31641:
URL: https://github.com/apache/superset/issues/31641#issuecomment-2574668141

   > > > > Should be resolved with PyODPS 0.12.2 release. See https://github.com/aliyun/aliyun-odps-python-sdk/releases/tag/v0.12.2 for details.
   > > > 
   > > > 
   > > > 
   > > > 1. When I uninstalled the old version 0.12.1.1 of pyodps and installed the new version 0.12.2, the same error was reported. The details are as follows
   > > >    ![image](https://private-user-images.githubusercontent.com/79888193/400117323-46e76bf5-3320-4586-89ae-acf81577500c.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTczMjMtNDZlNzZiZjUtMzMyMC00NTg2LTg5YWUtYWNmODE1Nzc1MDBjLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTVmNzc2NjEzNTczZTk5ODcxOGI0MTdkNjA0NmU5NjJkMzczZTc0Yjk2OTRmYzhjNWE5ZWQyMTlkMTM1NTg2YzMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.h749N4XHCZ_uv6WcdKVf6Qu_NSmBIWp0LOi0suo7r6g)
   > > > 2. I suspect there is something wrong with the way the connection is made, or pyodps doesn't really fix the error.
   > > >    ![image](https://private-user-images.githubusercontent.com/79888193/400117430-a0ef5aa8-59b5-41e2-a554-78d959cfd807.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMTMxNDUsIm5iZiI6MTczNjIxMjg0NSwicGF0aCI6Ii83OTg4ODE5My80MDAxMTc0MzAtYTBlZjVhYTgtNTliNS00MWUyLWE1NTQtNzhkOTU5Y2ZkODA3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAxMDclMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMTA3VDAxMjA0NVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTIxNzRmN2U1NzBjNzg5NzM0ZDFiMWEzNmQ3YjYxZmJiMWYzNzVkZjlmYmZiZmQ3NzJhYWM4MmRlOTIzYTY5NWYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0._D--wmDoQfnCyc4iMKJnAs4Qf_hcFFVPLA6XFmqUA_o)
   > > 
   > > 
   > > <img alt="image" width="1788" src="https://private-user-images.githubusercontent.com/8284922/400602641-50ad4dc5-0e48-44cd-8ce5-8516809f5381.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MzYyMjY5MTgsIm5iZiI6MTczNjIyNjYxOCwicGF0aCI6Ii84Mjg0OTIyLzQwMDYwMjY0MS01MGFkNGRjNS0wZTQ4LTQ0Y2QtOGNlNS04NTE2ODA5ZjUzODEucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI1MDEwNyUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNTAxMDdUMDUxMDE4WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9M2FkNzU3ZGU3MDUwYjZkNmM2NDY1ZmFmYzBmYjAzY2YxNDgxMWRjNmZiYjcwMzE5NWZmYjVhZjljMmI4OWI4NiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.gouGY2DnioE5ho_7BSGca8tfj6eGClb8G1ktdixTl-g"> Works for me. Given the error message it is quite possible that the correct version is not properly installed for superset as the function signature is already correct for the l
 atest version of superset.
   > 
   > I'm curious how you deployed the superset service. I installed it through k8s helm chart, and then pip install pyodps==0.12.2; my superset version is 4.1.1
   
   Installed with pip inside a virtualenv on host without any containers.


-- 
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: notifications-unsubscribe@superset.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org