cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

4 REPLIES 4

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

@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

ramravi
Contributor II

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

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

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!