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

ASF GitHub Bot commented on FLINK-7205:
---------------------------------------

hequn8128 commented on issue #6381: [FLINK-7205] [table] Add UUID supported in 
SQL and TableApi
URL: https://github.com/apache/flink/pull/6381#issuecomment-410680365
 
 
   @buptljy Ok, you are right.
   How about add a test in `CalcITCase` in package of 
`org.apache.flink.table.runtime.stream.table`. 
   
   ```
     @Test
     def testUDFNotDeterministic(): Unit = {
       val env = StreamExecutionEnvironment.getExecutionEnvironment
       val tEnv = TableEnvironment.getTableEnvironment(env)
       StreamITCase.testResults = mutable.MutableList()
       val ds = 
StreamTestData.getSmall3TupleDataStream(env).toTable(tEnv).select(uuid())
   
       val results = ds.toAppendStream[Row]
       results.print()
       results.addSink(new StreamITCase.StringSink[Row])
       env.execute()
   
       assert(StreamITCase.testResults.distinct.size > 1)
     }
   ```

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


> Add UUID supported in TableAPI/SQL
> ----------------------------------
>
>                 Key: FLINK-7205
>                 URL: https://issues.apache.org/jira/browse/FLINK-7205
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table API & SQL
>    Affects Versions: 1.4.0
>            Reporter: sunjincheng
>            Assignee: buptljy
>            Priority: Major
>              Labels: pull-request-available
>
> UUID() returns a value that conforms to UUID version 1 as described in RFC 
> 4122. The value is a 128-bit number represented as a utf8 string of five 
> hexadecimal numbers in aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee format:
> The first three numbers are generated from the low, middle, and high parts of 
> a timestamp. The high part also includes the UUID version number.
> The fourth number preserves temporal uniqueness in case the timestamp value 
> loses monotonicity (for example, due to daylight saving time).
> The fifth number is an IEEE 802 node number that provides spatial uniqueness. 
> A random number is substituted if the latter is not available (for example, 
> because the host device has no Ethernet card, or it is unknown how to find 
> the hardware address of an interface on the host operating system). In this 
> case, spatial uniqueness cannot be guaranteed. Nevertheless, a collision 
> should have very low probability.
> See: [RFC 4122: 
> http://www.ietf.org/rfc/rfc4122.txt|http://www.ietf.org/rfc/rfc4122.txt]
> See detailed semantics:
>    MySql: 
> [https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_uuid|https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html#function_uuid]
> Welcome anybody feedback -:).



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to