Getting Started With The Apache Sedona Docker Image

Apache Sedona
1

I am referring to this tutorial: https://www.youtube.com/watch?v=WZ-vv7c6YSg&ab_channel=WilliamLyon
Hi there, when I replicate the same code, at line 9, I get the following error:

AnalysisException: [TABLE_OR_VIEW_NOT_FOUND] The table or view basins cannot be found. Verify the spelling and correctness of the schema and catalog.
If you did not qualify the name with a schema, verify the current_schema() output, or qualify the name with the correct schema and catalogue.

I run hucs_df.createOrReplaceTempView(“basins”) and this is working fine and creating the view but line 9 does give me the error.

1 Like
2

Hi @iamraj -

Can you share the full code you are running and I will try to reproduce?

1 Like
3

sounds good, I am loading data from s3 and running on the wherobots cloud.

Here is the code:
https://wbc.wherobots.services/jupyter/qoiznqsqwo/qleaaqjeilcv3q/lab/tree/Untitled.ipynb

let me know, if you can access it?

4

Looks like that notebook is private to your Wherobots account so I can’t access it.

The best way to share the notebook is probably to download from the Jupyter environment and then share via GitHub or even something like PasteBin to share the raw notebook contents.

5

sorry, here is the Pastebin

6

Thanks!

On line 13 instead of

hucs_df.createOrReplaceGlobalTempView("basins")

can you try

hucs_df.createOrReplaceTempView("basins")
2 Likes
7

That worked, thank you!

2 Likes