evadb.executor.executor_utils.ExecutorError: could not convert string to float: '2022-09-19'

[haoranx3]

Search before asking

• I have searched the EvaDB issues and found no similar bug report.

Bug

Running into error could not convert string to float: '2022-09-19' when creating a forecast function as follow:

cursor.query("""
  CREATE FUNCTION IF NOT EXISTS StockPriceForecast FROM
    (
      SELECT date, open, close, high, low, volume
      FROM postgres_data.historical_stock_price
    )
  TYPE Forecasting
  PREDICT 'high'
  TIME 'date'
  FREQUENCY 'W'
""").df()

Table schema:

CREATE TABLE IF NOT EXISTS historical_stock_price (date VARCHAR(64), open decimal, close decimal, high decimal, low decimal, volume INT)

Example data set:

Date	Open	High	Low	Close	Volume
2022-09-20	242.07000732421900	243.50999450683600	239.63999938964800	242.4499969482420	26660300
2022-09-21	244.27000427246100	247.66000366210900	238.89999389648400	238.9499969482420	28625600

Environment

• evaDB: 0.3.4
• Python: 3.11
• os: Mac

Are you willing to submit a PR?

• Yes I'd like to help by submitting a PR!

[github-actions]

👋 Hello @haoranx3, thanks for your interest in EVA DB 🙏 Please visit our 🔮 Tutorials to get started, where you can find quickstart guides for simple tasks like Image Classification all the way to more interesting tasks like Emotion Analysis.

If this is a 🐞 Bug Report, please provide a minimum reproducible example to help us debug it.

If this is a ❓ Question, please provide as much information as possible, including dataset examples and query results.

[xzdandy]

Hi @haoranx3, could you try installing the latest EvaDB? I can not reproduce this error on EvaDB v0.3.6. Notice, you need the following query on the latest EvaDB.

CREATE FUNCTION IF NOT EXISTS StockPriceForecast FROM
    (
      SELECT date, high
      FROM postgres_data.historical_stock_price
    )
  TYPE Forecasting
  PREDICT 'high'
  TIME 'date'
  FREQUENCY 'W';

[haoranx3]

Thank you! upgrading evadb solves the issue