I want to pull data from foxpro into hdfs or hive.
I'm not getting any reference for it.
This is not something we see often and I haven't tested it but it should work.
You should be able to use Sqoop, connecting to FoxPro using a JDBC driver (e.g. https://www.dbschema.com/foxpro-jdbc-driver.html)