apache / apache/beam

Add support for mapping columns to pubsub message attributes in flat schemas DDL

Open
#20,006 0 comments 0 reactions 0 assignees View on GitHub
dsl improvement P3 sql
Dominant language
Java
Stars
8.7k
Forks
4.7k
Avg merge
1d 20h
Merged PRs (30d)
196

Description

Context: https://lists.apache.org/thread.html/bf4c37f21bda194d7f8c40f6e7b9a776262415755cc1658412af3c76%40%3Cdev.beam.apache.org%3E

The syntax should look something like this (proposed by [~alexvanboxel]):
```

CREATE TABLE people (
my_timestamp TIMESTAMP *OPTION(ref="pubsub:event_timestamp)*,
my_id
VARCHAR *OPTION(ref="pubsub:attributes['id_name']")*,
name VARCHAR,
age INTEGER
)
TYPE
'pubsub'
LOCATION 'projects/my-project/topics/my-topic'

```

This jira pertains specifically to the my_id field in this example.

Imported from Jira [BEAM-9208](https://issues.apache.org/jira/browse/BEAM-9208). Original Jira may contain additional context.
Reported by: bhulette.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.