Getting "java.io.FileNotFoundException" when I'm trying to use wildcard character

Varshith
New Contributor III

Though there are parquet files in the folder which I'm trying to query, I'm getting FileNotFoundException. Please Let me know if there is any issue in the code.

Thanks

Aviral-Bhardwaj
Esteemed Contributor III

@Varshith K​  the actual path is

/dbfs/user/hive/warehouse/a/*.parquet

or

/user/hive/warehouse/a/*.parquet

check both and I am pretty sure that 1st one will work

Please select this answer as best answer if it resolved your issue

Thanks

Aviral Bhardwaj

AviralBhardwaj

@Aviral Bhardwaj​ 

Hi Aviral,

Actually when I'm giving "dbfs:/user/hive/warehouse/a/" or "/user/hive/warehouse/a/" as path then there is no issue, but when I'm trying to use wildcard character to find the parquet files in that folder then it is throwing error. Please refer to the attached screenshot

Thanks,

Varshith

Aviral-Bhardwaj
Esteemed Contributor III

Hey @Varshith K​  Connect with me at https://www.linkedin.com/in/aviralb/

we will set up a meeting link and I will try to help you

AviralBhardwaj

ramravi
Contributor II

alternatively you can use this as shell command. This will work.

%sh
 
ls /dbfs/mnt/mountpoint/path/to/raw/*.parquet