That isn't the issue - the table does not exist anyway, but the storage
path does.
On Tue, Aug 2, 2022 at 6:48 AM Stelios Philippou wrote:
> HI Kumba.
>
> SQL Structure is a bit different for
> CREATE OR REPLACE TABLE
>
>
> You can only do the following
> CREATE TABLE IF NOT EXISTS
>
>
>
>
>
HI Kumba.
SQL Structure is a bit different for
CREATE OR REPLACE TABLE
You can only do the following
CREATE TABLE IF NOT EXISTS
https://spark.apache.org/docs/3.3.0/sql-ref-syntax-ddl-create-table-datasource.html
On Tue, 2 Aug 2022 at 14:38, Sean Owen wrote:
> I don't think "CREATE OR
I don't think "CREATE OR REPLACE TABLE" exists (in SQL?); this isn't a VIEW.
Delete the path first; that's simplest.
On Tue, Aug 2, 2022 at 12:55 AM Kumba Janga wrote:
> Thanks Sean! That was a simple fix. I changed it to "Create or Replace
> Table" but now I am getting the following error. I
Hi
I strongly suggest to use print prepared sqls and try them in raw form. The
error you posted points to a syntax error.
On Tue, 2 Aug 2022 at 3:56 pm, Kumba Janga wrote:
> Thanks Sean! That was a simple fix. I changed it to "Create or Replace
> Table" but now I am getting the following
Thanks Sean! That was a simple fix. I changed it to "Create or Replace
Table" but now I am getting the following error. I am still researching
solutions but so far no luck.
ParseException:
mismatched input '' expecting {'ADD', 'AFTER', 'ALL', 'ALTER',
'ANALYZE', 'AND', 'ANTI', 'ANY', 'ARCHIVE',
Pretty much what it says? you are creating a table over a path that already
has data in it. You can't do that without mode=overwrite at least, if
that's what you intend.
On Mon, Aug 1, 2022 at 7:29 PM Kumba Janga wrote:
>
>
>- Component: Spark Delta, Spark SQL
>- Level: Beginner
>-
- Component: Spark Delta, Spark SQL
- Level: Beginner
- Scenario: Debug, How-to
*Python in Jupyter:*
import pyspark
import pyspark.sql.functions
from pyspark.sql import SparkSession
spark = (
SparkSession
.builder
.appName("programming")
.master("local")