[jira] [Commented] (FLINK-27806) Datagen add binary & varbinary type support

["Ran Tao (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-27806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17542760#comment-17542760 ] 

Ran Tao commented on FLINK-27806:
---------------------------------

random:
CREATE TABLE t1 (
    f0 BIGINT,
    f1 BINARY,
    f2 VARBINARY
) WITH (
  'connector' = 'datagen',
  'rows-per-second'='5',
  'number-of-rows'='10',
  'fields.f1.kind'='random',
  'fields.f2.kind'='random'
); 
!random.png! 

sequence:
CREATE TABLE t2 (
    f0 BIGINT,
    f1 BINARY,
    f2 VARBINARY
) WITH (
  'connector' = 'datagen',
  'rows-per-second'='5',
  'number-of-rows'='10',
  'fields.f1.kind'='sequence',
  'fields.f1.start'='100',
  'fields.f1.end'='10000',
  'fields.f2.kind'='sequence',
  'fields.f2.start'='500',
  'fields.f2.end'='50000'
);
 !sequence.png! 

> Datagen add binary & varbinary  type support
> --------------------------------------------
>
>                 Key: FLINK-27806
>                 URL: https://issues.apache.org/jira/browse/FLINK-27806
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / Ecosystem
>    Affects Versions: 1.15.0, 1.14.4
>            Reporter: Ran Tao
>            Priority: Minor
>              Labels: pull-request-available
>         Attachments: random.png, sequence.png
>
>
> Datagen connector currently not support BYTES type. e.g. BINARY & VARBINARY. It will cause exception when use
> CREATE TABLE t3 (
>     f0 BIGINT,
>     f1 VARBINARY
> ) WITH (
>   'connector' = 'datagen',
>   ....
> );
> StackTrace:
> Caused by: org.apache.flink.table.api.ValidationException: Unsupported type: BYTES at org.apache.flink.connector.datagen.table.RandomGeneratorVisitor.defaultMethod(RandomGeneratorVisitor.java:317) at org.apache.flink.connector.datagen.table.RandomGeneratorVisitor.defaultMethod(RandomGeneratorVisitor.java:60) at org.apache.flink.table.types.logical.utils.LogicalTypeDefaultVisitor.visit(LogicalTypeDefaultVisitor.java:82) at org.apache.flink.table.types.logical.VarBinaryType.accept(VarBinaryType.java:151) at org.apache.flink.connector.datagen.table.DataGenTableSourceFactory.createContainer(DataGenTableSourceFactory.java:128) at org.apache.flink.connector.datagen.table.DataGenTableSourceFactory.createDynamicTableSource(DataGenTableSourceFactory.java:98) at org.apache.flink.table.factories.FactoryUtil.createTableSource(FactoryUtil.java:147)



--
This message was sent by Atlassian Jira
(v8.20.7#820007)