This question is cross-posted on StackOverflow
https://stackoverflow.com/questions/66687797/pyflink-java-io-eofexception-at-java-io-datainputstream-readint
I have a PyFlink job that reads from Kafka source, transform, and write to
Kafka sink. This is a `tree` view of my working directory.
```
> tree
.
├── deps
│ └── flink-sql-connector-kafka_2.12-1.12.0.jar
├── flink_run.sh
├── main.py
├── pyflink1.12.0.zip
└── tasks
└── user_last_n_clicks
├── sink_ddl.sql
├── source_ddl.sql
└── transform_dml.sql
```
This is the `flink_run.sh`:
```
flink run \
--yarnname test-pyflink \
-m yarn-cluster \
-yD yarn.application.queue=tech_platform \
-pyarch pyflink1.12.0.zip \
-pyexec /data/software/pyflink1.12.0/bin/python \
-py main.py testing user_last_n_clicks
```
This is the `main.py`. The key logic is in:
- `parse_content` udf.
- load sql files from tasks subfolder, and execute_sql
```python
import os
from sys import argv
from pyflink.datastream import StreamExecutionEnvironment
from pyflink.table import StreamTableEnvironment, EnvironmentSettings,
DataTypes
from pyflink.table.udf import udf
def read_file_content(filepath):
with open(filepath) as f:
return f.read()
@udf(input_types=[DataTypes.STRING()],
result_type=DataTypes.MAP(DataTypes.STRING(), DataTypes.STRING()))
def parse_content(content_str):
import json
res = {}
content = json.loads(content_str)
if 'postId' in content:
res['item_id'] = content['postId']
if 'lid' in content:
res['item_id'] = content['lid']
if 'param' in content and 'tag' in content['param']:
res['tag'] = content['param']['tag']
return res
CWD = os.getcwd()
_, palfish_env, task = argv
VALID_PALFISH_ENVS = ['development', 'testing', 'production']
if palfish_env not in VALID_PALFISH_ENVS:
raise Exception(f"{palfish_env} is not a valid env, should be one of
[{', '.join(VALID_PALFISH_ENVS)}].")
VALID_TASKS = os.listdir(f"{CWD}/tasks")
if task not in VALID_TASKS:
raise Exception(f"{task} is not a valid task, should be one of [{',
'.join(VALID_TASKS)}].")
config = {
"development": {
"${generation.kafka.source.servers}": "localhost:9094",
"${generation.kafka.sink.servers}": "localhost:9094"
},
"testing": {
"${generation.kafka.source.servers}": "10.111.135.233:9092,
10.111.130.11:9092,10.111.130.12:9092",
"${generation.kafka.sink.servers}": "10.111.135.233:9092,
10.111.130.11:9092,10.111.130.12:9092"
},
"production": {
"${generation.kafka.source.servers}": "10.111.203.9:9092,
10.111.203.10:9092,10.111.203.13:9092,10.111.204.163:9092,
10.111.204.164:9092,10.111.204.165:9092",
"${generation.kafka.sink.servers}": "10.111.209.219:9092,
10.111.209.220:9092,10.111.209.221:9092"
}
}
FAT_JAR_PATH = f"{CWD}/deps/flink-sql-connector-kafka_2.12-1.12.0.jar"
source_ddl =
read_file_content(f'{CWD}/tasks/{task}/source_ddl.sql').replace('${generation.kafka.source.servers}',
config[palfish_env]['${generation.kafka.source.servers}'])
sink_ddl =
read_file_content(f'{CWD}/tasks/{task}/sink_ddl.sql').replace('${generation.kafka.sink.servers}',
config[palfish_env]['${generation.kafka.sink.servers}'])
transform_dml = read_file_content(f'{CWD}/tasks/{task}/transform_dml.sql')
exec_env = StreamExecutionEnvironment.get_execution_environment()
env_settings = EnvironmentSettings.Builder().use_blink_planner().build()
t_env =
StreamTableEnvironment.create(stream_execution_environment=exec_env,
environment_settings=env_settings)
t_env.get_config().get_configuration().set_string("pipeline.jars",
f"file://{FAT_JAR_PATH}")
t_env.create_temporary_function("ParseContent", parse_content)
t_env.execute_sql(source_ddl)
t_env.execute_sql(sink_ddl)
t_env.execute_sql(transform_dml).wait()
```
See my sqls. Note the udf `ParseContent` is used in `transform_dml.sql`.
```sql
# source_ddl.sql
CREATE TABLE kafka_source (
`body` ROW<`log` ROW<`uid` BIGINT, serverts BIGINT, `contentstr` STRING>>
) WITH (
'connector' = 'kafka',
'topic' = 'data-report-stat-old-logtype7',
'properties.bootstrap.servers' = '${generation.kafka.source.servers}',
'properties.group.id' = 'flink-featurepipelines',
'format' = 'json'
)
# transform_ddl.sql
INSERT INTO kafka_sink
WITH t1 AS (
SELECT body['log']['uid'] user_id, ParseContent(body['log']['contentstr'])
content, body['log']['serverts'] server_ts
FROM kafka_source
),
t2 AS (
SELECT user_id, content['item_id'] item_id, content['tag'] tag, server_ts
FROM t1
WHERE content['item_id'] IS NOT NULL
AND content['tag'] = '点击帖子卡片'
),
last_n AS (
SELECT user_id, item_id, server_ts
FROM (
SELECT *,
ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY server_ts DESC) as row_num
FROM t2)
WHERE row_num <= 5
)
SELECT user_id, CAST(MAX(server_ts / 1000) AS TIMESTAMP) datetime,
LISTAGG(CAST(item_id AS STRING)) last_5_clicks
FROM last_n
GROUP BY user_id
# sink_ddl.sql
CREATE TABLE kafka_sink (
user_id BIGINT,
datetime TIMESTAMP(3),
last_5_clicks STRING,
PRIMARY KEY (user_id) NOT ENFORCED
) WITH (
'connector' = 'upsert-kafka',
'topic' = 'aiinfra.fct.userfeature.0',
'properties.bootstrap.servers' = '${generation.kafka.sink.servers}',
'key.format' = 'json',
'value.format' = 'json'
)
```
I got the error when running the PyFlink program in my testing environment
machine.
```
Caused by: java.io.EOFException
at java.io.DataInputStream.readInt(DataInputStream.java:392)
~[?:1.8.0_261]
at
org.apache.flink.table.runtime.typeutils.StringDataSerializer.deserializeInternal(StringDataSerializer.java:91)
~[flink-table-blink_2.11-1.12.0.jar:1.12.0]
at
org.apache.flink.table.runtime.typeutils.StringDataSerializer.deserialize(StringDataSerializer.java:87)
~[flink-table-blink_2.11-1.12.0.jar:1.12.0]
at
org.apache.flink.table.runtime.typeutils.StringDataSerializer.deserialize(StringDataSerializer.java:36)
~[flink-table-blink_2.11-1.12.0.jar:1.12.0]
at
org.apache.flink.table.runtime.typeutils.serializers.python.MapDataSerializer.deserializeInternal(MapDataSerializer.java:124)
~[flink-python_2.11-1.12.0.jar:1.12.0]
at
org.apache.flink.table.runtime.typeutils.serializers.python.MapDataSerializer.deserialize(MapDataSerializer.java:107)
~[flink-python_2.11-1.12.0.jar:1.12.0]
at
org.apache.flink.table.runtime.typeutils.serializers.python.MapDataSerializer.deserialize(MapDataSerializer.java:46)
~[flink-python_2.11-1.12.0.jar:1.12.0]
at
org.apache.flink.table.runtime.typeutils.serializers.python.RowDataSerializer.deserialize(RowDataSerializer.java:104)
~[flink-python_2.11-1.12.0.jar:1.12.0]
at
org.apache.flink.table.runtime.typeutils.serializers.python.RowDataSerializer.deserialize(RowDataSerializer.java:49)
~[flink-python_2.11-1.12.0.jar:1.12.0]
at
org.apache.flink.table.runtime.operators.python.scalar.RowDataPythonScalarFunctionOperator.emitResult(RowDataPythonScalarFunctionOperator.java:84)
~[flink-python_2.11-1.12.0.jar:1.12.0]
```
Here are the full logs, see
https://gist.github.com/YikSanChan/d3a5d25cdf2f3c1dc6b3dc93e48c4bbc.
Any idea why the exception? Thanks.
Yik San