You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by "djouallah (via GitHub)" <gi...@apache.org> on 2023/03/19 06:24:01 UTC

[GitHub] [arrow-datafusion-python] djouallah opened a new issue, #291: make the methode show() print the results

djouallah opened a new issue, #291:
URL: https://github.com/apache/arrow-datafusion-python/issues/291

   for a compatibility with spark and Duckdb , can you please make ctx.sql('select 42').show() print the results please.
   
   btw, version 8 is a very solid improvement !!!


-- 
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: github-unsubscribe@arrow.apache.org.apache.org

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

[GitHub] [arrow-datafusion-python] simicd commented on issue #291: make the method show() print the results

Posted by "simicd (via GitHub)" <gi...@apache.org>.
simicd commented on issue #291:
URL: https://github.com/apache/arrow-datafusion-python/issues/291#issuecomment-1478533335

   Thanks for the hint & additional context @djouallah, I was able to reproduce this in Jupyter notebooks now. I will take a look at how duckdb & PySpark are implementing the method In the meantime you can just drop `.show()` to preview the dataframe until the root cause of the issue is found:
   
   ![image](https://user-images.githubusercontent.com/10134699/226731670-bcad7f50-a302-4c0d-af6b-734079f45dc5.png)
   


-- 
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: github-unsubscribe@arrow.apache.org

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

[GitHub] [arrow-datafusion-python] djouallah commented on issue #291: make the method show() print the results

Posted by "djouallah (via GitHub)" <gi...@apache.org>.
djouallah commented on issue #291:
URL: https://github.com/apache/arrow-datafusion-python/issues/291#issuecomment-1477083219

   tried this in colab
   ![image](https://user-images.githubusercontent.com/12554469/226487223-f7dad3dd-50b0-4c67-aa8e-e066efafe18e.png)
   
   why duckdb and pyspark works out of the box, can you do the same as they are doing ?


-- 
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: github-unsubscribe@arrow.apache.org

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

[GitHub] [arrow-datafusion-python] simicd commented on issue #291: make the method show() print the results

Posted by "simicd (via GitHub)" <gi...@apache.org>.
simicd commented on issue #291:
URL: https://github.com/apache/arrow-datafusion-python/issues/291#issuecomment-1477059926

   Hi @djouallah, thanks for reporting the issue and the feedback! I tried to reproduce the problem. When debugging in e.g. VS Code and run `ctx.sql("SELECT 42").show()` the result is not printed in the debug console but by default in the terminal. This is due to VS Code's debug settings:
   
   **Debug console**
   ![image](https://user-images.githubusercontent.com/10134699/226481590-7a1ec6a3-6623-43a9-a996-ef2cd7faf6ad.png)
   
   **Terminal**
   ![image](https://user-images.githubusercontent.com/10134699/226483524-4eeec0ae-2a25-4932-a584-7b74ad3746ca.png)
   
   
   
   I assume you'd like to show terminal outputs in the debug console. If that's the case you'd need to set the VS Code config to internal console in `launch.json` as follows:
   ```
   {
       // Use IntelliSense to learn about possible attributes.
       // Hover to view descriptions of existing attributes.
       // For more information, visit: https://go.microsoft.com/fwlink/?linkid=830387
       "version": "0.2.0",
       "configurations": [
           {
               "name": "Python: Debug",
               "type": "python",
               "request": "launch",
               "program": "${file}",
               "console": "internalConsole",
             }
       ]
   }
   ```
   
   Once that's set both `.show()` will be printed in the same console:
   ![image](https://user-images.githubusercontent.com/10134699/226482751-39241d83-93da-4f61-a520-45ac6fdf6e61.png)
   
   This is assuming that you're using VS Code, chances are that if you're using another editor you will have similar possibilty to configure the output. Hope that helps, please feel free to share additional context if this is not what you were looking for


-- 
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: github-unsubscribe@arrow.apache.org

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

[GitHub] [arrow-datafusion-python] andygrove closed issue #291: make the method show() print the results

Posted by "andygrove (via GitHub)" <gi...@apache.org>.
andygrove closed issue #291: make the method show() print the results 
URL: https://github.com/apache/arrow-datafusion-python/issues/291


-- 
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: github-unsubscribe@arrow.apache.org

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