Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
Description
I would like to suggest the possibility of developing a ZIP Type CONNECT Storage Engine, which could work directly with ZIP files (which contain CSV or XML into them) without the need of previously decompressing such files and importing them into the database.
Thank you. Hope my suggestion is useful.
Kind regards,
Juan Telleria
Attachments
Issue Links
- relates to
-
MDEV-12354 MariaDB CONNECT CSV (Zipped Tables)
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Olivier Bertrand [ bertrandop ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Attachment | Data Structure.png [ 43001 ] |
| issue.field.resolutiondate | 2016-12-26 11:41:18.0 | 2016-12-26 11:41:18.899 |
| Fix Version/s | 10.0.29 [ 22312 ] | |
| Fix Version/s | 10.1.21 [ 22113 ] | |
| Fix Version/s | 10.2.4 [ 22116 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Attachment | Folder Example.png [ 43316 ] |
| Attachment | Subfolder Option.PNG [ 43394 ] |
| Comment |
[ Hi!
Could the "subfolder" option be developed please (in case it only takes little work, otherwise no) before MariaDB 10.2.4 RC turns out to be GA. They have changed the data structure in my work from monthly folders to daily folders, and is somehow a chaos :P: !Subfolder Option.PNG|thumbnail! Thank you :-) ] |
| Comment |
[ Some ideas for subfolder option (From Stack Overflow):
[Move all files in subfolders to a parent folder|http://superuser.com/questions/999922/move-all-files-from-multiple-subfolders-into-the-parent-folder] But actually, I would not move the files (nor copy them), because that is time consuming; and I would simply perform in C# the following command: [For /R (CMD)|https://ss64.com/nt/for_r.html] ] |
| Comment |
[ * New sub-folder option (_multiple=3_) Information could be added to Knowledge Base documentation.
* ¿Will it be distributed from MariaDB 10.2.4 RC?. ] |
| Comment |
[ *ERRORS:*
* Got error 174 'Open() error 13 on C:/Users/ANALISISOTS/Desktop/GA155AL15012017.csv: Permission denied' from CONNECT. * Got error 174 'Zipfile open error on C:/Users/ANALISISOTS/Desktop/GA155AL15012017.zip' from CONNECT. Are due to Directory permission issues on Windows: Same CREATE TABLE for CONNECT CSV (Zipped = 1 | 0) works perfectly on MariaDB 10.1 directory, but it does not work on other Windows paths. This is due to the fact that mysqld can only read MariaDB 10.1 folder. ¿Which would be the easiest way to solve this? Thank you. ] |
| Attachment | error log.log [ 43490 ] |
| Link |
This issue relates to |
| Attachment | P700-error.log [ 43493 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Attachment | Test Data.zip [ 43494 ] |
| Attachment | connect.zip [ 43504 ] |
| Attachment | CONNECT CSV Table Type.pdf [ 43508 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Summary | SUGGESTION: CONNECT Storage Engine - ZIP Engine | CONNECT Storage Engine - ZIP Engine |
| Workflow | MariaDB v3 [ 78319 ] | MariaDB v4 [ 133001 ] |