- 2405 Views
- 2 replies
- 2 kudos
Illegal character in partition path when attempting REORG ... (PURGE)
I have a large delta table partitioned by an identifier column that I now have discovered has blank spaces in some of the identifiers, e.g. one partition can be defined by "Identifier=first identifier". Most partitions does not have these blank space...
- 2405 Views
- 2 replies
- 2 kudos
- 2 kudos
Hi @bearys, The error message suggests an illegal character in the path at a specific index. The error is pointing to a blank space in the path "dbfs:/mnt/container/table_name/Identifier=first identifier/part-01347-8a9a157b-6d0d-75dd-b1b7-2aed12e057...
- 2 kudos
- 3440 Views
- 6 replies
- 7 kudos
Resolved! How can I delete a file in DBFS with Illegal character?
How can I delete a file in DBFS with Illegal character?Someone put the file named "planejamento_[4098.]___SHORT_SAIA_JEANS__.xlsx" inside the folder /FileStore and I can delete it, because of this error: java.net.URISyntaxException: Illegal character...
- 3440 Views
- 6 replies
- 7 kudos
- 7 kudos
try this %sh ls -li /dbfsif the file is located in a subdirectory you can change the path mentioned above.the %sh magic command gives you access to linux shell commands.
- 7 kudos