How can I do forecasting with different type of data

I'm a little confused by what you mean by "different type" of data. You can use Vertica's external tables to query data like Parquet, ORC, JSON, Avro, etc. Or, you can import that data into the database. Either way, you can do a lot of analytics and forecasting on any of that data with the built-in analytics and machine learning functions. Does that help? If not, go ahead and ping us more directly so we can understand your problem better. Or maybe someone else is doing something similar. You might check the user forum: https://forum.vertica.com/