[Python] Hopsworks problem when inserting a dataframe in a Future Group

Discussão em 'Python' iniciado por Stack, Março 16, 2025.

  1. Stack

    Stack Membro Participativo

    I am trying to insert a dataframe in a Hopsworks Future Group as follows:


    feature_group = feature_store.create_feature_group(
    name="player_features",
    version = 1,
    description="Description here",
    online_enabled=True,
    features=[
    {"name": "player_id", "type": "bigint"},
    {"name": "last_season", "type": "bigint"},
    {"name": "current_team_id", "type": "bigint"},
    {"name": "height_in_cm", "type": "double"},
    {"name": "market_value_in_eur", "type": "double"},
    {"name": "highest_market_value_in_eur", "type": "double"}
    ],
    primary_key= ["player_id"]
    )


    feature_group.insert(data_cleaned)

    The Feature Group is created but no data is inserting.

    Hopsworks Feature Group No data and a server error

    HTTP code: 500, HTTP reason: Internal Server Error, body: b'{"errorCode":270066,"usrMsg":"project: WINNING, database: winning, db user:WINNING_torres19, jdbcString: jdbc:mysql://10.2.5.47:3306/winning?useSSL=false&allowPublicKeyRetrieval=true","devMsg":"Access denied for user \'WINNING_torres19\'@\'%\' to database \'winning\'","errorMsg":"Could not initiate connection to MySQL Server"}', error code: 270066, error msg: Could not initiate connection to MySQL Server, user msg: project: WINNING, database: winning, db user:WINNING_torres19, jdbcString: jdbc:mysql://10.2.5.47:3306/winning?useSSL=false&allowPublicKeyRetrieval=true

    I also had an error in a previous insert I did about Kafka Producer or something like this and also the Future Group was created but no data inside. It's strange because I have set all the properties correctly when I created the Future Store and also connected well to the Future Store with my API key and so, but I'm having issues with the Server and connection...

    I hope someone have an idea about whats happening, I know this framework is very new.

    Regards

    Continue reading...

Compartilhe esta Página