[jira] [Updated] (SPARK-43382) Read and write csv and json files. Archive files such as zip or gz are supported

2023-05-19 Thread Sean R. Owen (Jira) 


 [ 
https://issues.apache.org/jira/browse/SPARK-43382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Sean R. Owen updated SPARK-43382:
-
Issue Type: Improvement  (was: Bug)
  Priority: Minor  (was: Major)

> Read and write csv and json files. Archive files such as zip or gz are 
> supported
> 
>
> Key: SPARK-43382
> URL: https://issues.apache.org/jira/browse/SPARK-43382
> Project: Spark
>  Issue Type: Improvement
>  Components: SQL
>Affects Versions: 3.5.0
>Reporter: melin
>Priority: Minor
>
> snowflake data import and export, support fixed files. For example:
>  
> {code:java}
> COPY INTO @mystage/data.csv.gz 
>  
> COPY INTO mytable 
> FROM @my_ext_stage/tutorials/dataloading/sales.json.gz; 
> FILE_FORMAT = (TYPE = 'JSON') 
> MATCH_BY_COLUMN_NAME='CASE_INSENSITIVE'; 
>  
> {code}
> Can spark directly read archive files?
> {code:java}
> spark.read.csv("/tutorials/dataloading/sales.json.gz")
> {code}
> @[~kaifeiYi] 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Updated] (SPARK-43382) Read and write csv and json files. Archive files such as zip or gz are supported

2023-05-07 Thread melin (Jira) 


 [ 
https://issues.apache.org/jira/browse/SPARK-43382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

melin updated SPARK-43382:
--
Description: 
snowflake data import and export, support fixed files. For example:

 
{code:java}
COPY INTO @mystage/data.csv.gz 
 
COPY INTO mytable 
FROM @my_ext_stage/tutorials/dataloading/sales.json.gz; 
FILE_FORMAT = (TYPE = 'JSON') 
MATCH_BY_COLUMN_NAME='CASE_INSENSITIVE'; 
 
{code}
Can spark directly read archive files?
{code:java}
spark.read.csv("/tutorials/dataloading/sales.json.gz")

{code}
@[~kaifeiYi] 

  was:
snowflake data import and export, support fixed files. For example:

 
{code:java}
COPY INTO @mystage/data.csv.gz 
 
COPY INTO mytable 
FROM @my_ext_stage/tutorials/dataloading/sales.json.gz; 
FILE_FORMAT = (TYPE = 'JSON') 
MATCH_BY_COLUMN_NAME='CASE_INSENSITIVE'; 
 
{code}
Can spark directly read archive files?
{code:java}
spark.read.csv("/tutorials/dataloading/sales.json.gz"){code}
@[~kaifeiYi] 


> Read and write csv and json files. Archive files such as zip or gz are 
> supported
> 
>
> Key: SPARK-43382
> URL: https://issues.apache.org/jira/browse/SPARK-43382
> Project: Spark
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 3.5.0
>Reporter: melin
>Priority: Major
>
> snowflake data import and export, support fixed files. For example:
>  
> {code:java}
> COPY INTO @mystage/data.csv.gz 
>  
> COPY INTO mytable 
> FROM @my_ext_stage/tutorials/dataloading/sales.json.gz; 
> FILE_FORMAT = (TYPE = 'JSON') 
> MATCH_BY_COLUMN_NAME='CASE_INSENSITIVE'; 
>  
> {code}
> Can spark directly read archive files?
> {code:java}
> spark.read.csv("/tutorials/dataloading/sales.json.gz")
> {code}
> @[~kaifeiYi] 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Updated] (SPARK-43382) Read and write csv and json files. Archive files such as zip or gz are supported

2023-05-05 Thread melin (Jira) 


 [ 
https://issues.apache.org/jira/browse/SPARK-43382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

melin updated SPARK-43382:
--
Description: 
snowflake data import and export, support fixed files. For example:

 
{code:java}
COPY INTO @mystage/data.csv.gz 
 
COPY INTO mytable 
FROM @my_ext_stage/tutorials/dataloading/sales.json.gz; 
FILE_FORMAT = (TYPE = 'JSON') 
MATCH_BY_COLUMN_NAME='CASE_INSENSITIVE'; 
 
{code}
Can spark directly read archive files?
{code:java}
spark.read.csv("/tutorials/dataloading/sales.json.gz"){code}
@[~kaifeiYi] 

  was:
snowflake data import and export, support fixed files. For example:

 
{code:java}
COPY INTO @mystage/data.csv.gz 
 
COPY INTO mytable 
FROM @my_ext_stage/tutorials/dataloading/sales.json.gz; 
FILE_FORMAT = (TYPE = 'JSON') 
MATCH_BY_COLUMN_NAME='CASE_INSENSITIVE'; 
 
{code}
Can spark directly read archive files?
{code:java}
spark.read.csv("/tutorials/dataloading/sales.json.gz"){code}
 


> Read and write csv and json files. Archive files such as zip or gz are 
> supported
> 
>
> Key: SPARK-43382
> URL: https://issues.apache.org/jira/browse/SPARK-43382
> Project: Spark
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 3.5.0
>Reporter: melin
>Priority: Major
>
> snowflake data import and export, support fixed files. For example:
>  
> {code:java}
> COPY INTO @mystage/data.csv.gz 
>  
> COPY INTO mytable 
> FROM @my_ext_stage/tutorials/dataloading/sales.json.gz; 
> FILE_FORMAT = (TYPE = 'JSON') 
> MATCH_BY_COLUMN_NAME='CASE_INSENSITIVE'; 
>  
> {code}
> Can spark directly read archive files?
> {code:java}
> spark.read.csv("/tutorials/dataloading/sales.json.gz"){code}
> @[~kaifeiYi] 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Updated] (SPARK-43382) Read and write csv and json files. Archive files such as zip or gz are supported

2023-05-05 Thread melin (Jira) 


 [ 
https://issues.apache.org/jira/browse/SPARK-43382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

melin updated SPARK-43382:
--
Description: 
snowflake data import and export, support fixed files. For example:

 
{code:java}
COPY INTO @mystage/data.csv.gz 
 
COPY INTO mytable 
FROM @my_ext_stage/tutorials/dataloading/sales.json.gz; 
FILE_FORMAT = (TYPE = 'JSON') 
MATCH_BY_COLUMN_NAME='CASE_INSENSITIVE'; 
 
{code}
Can spark directly read archive files?
{code:java}
spark.read.csv("/tutorials/dataloading/sales.json.gz"){code}
 

> Read and write csv and json files. Archive files such as zip or gz are 
> supported
> 
>
> Key: SPARK-43382
> URL: https://issues.apache.org/jira/browse/SPARK-43382
> Project: Spark
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 3.5.0
>Reporter: melin
>Priority: Major
>
> snowflake data import and export, support fixed files. For example:
>  
> {code:java}
> COPY INTO @mystage/data.csv.gz 
>  
> COPY INTO mytable 
> FROM @my_ext_stage/tutorials/dataloading/sales.json.gz; 
> FILE_FORMAT = (TYPE = 'JSON') 
> MATCH_BY_COLUMN_NAME='CASE_INSENSITIVE'; 
>  
> {code}
> Can spark directly read archive files?
> {code:java}
> spark.read.csv("/tutorials/dataloading/sales.json.gz"){code}
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

[jira] [Updated] (SPARK-43382) Read and write csv and json files. Archive files such as zip or gz are supported

2023-05-05 Thread melin (Jira) 


 [ 
https://issues.apache.org/jira/browse/SPARK-43382?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

melin updated SPARK-43382:
--
Environment: (was: snowflake data import and export, support fixed 
files. For example: 

 
{code:java}
COPY INTO @mystage/data.csv.gz 
 
COPY INTO mytable 
FROM @my_ext_stage/tutorials/dataloading/sales.json.gz; 
FILE_FORMAT = (TYPE = 'JSON') 
MATCH_BY_COLUMN_NAME='CASE_INSENSITIVE'; 
 
{code}
Can spark directly read archive files? 
{code:java}
spark.read.csv("/tutorials/dataloading/sales.json.gz"){code}
 )

> Read and write csv and json files. Archive files such as zip or gz are 
> supported
> 
>
> Key: SPARK-43382
> URL: https://issues.apache.org/jira/browse/SPARK-43382
> Project: Spark
>  Issue Type: Bug
>  Components: SQL
>Affects Versions: 3.5.0
>Reporter: melin
>Priority: Major
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)

-
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org