[FLINK-6893] Add BIN supported in SQL & Table API

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.4.0
• Fix Version/s: 1.5.0
• Component/s: Table SQL / API
• Assignee: sunjincheng
• Reporter: sunjincheng
• Created: 12/Jun/17 08:56
• Updated: 10/Jan/18 16:43
• Resolved: 10/Jan/18 16:43

Description

BIN(N) Returns a string representation of the binary value of N, where N is a longlong (BIGINT) number. This is equivalent to CONV(N,10,2). Returns NULL if N is NULL.

• Syntax:
  BIN(num)

• Arguments
  **num: a long/bigint value

• Return Types
  String

• Example:
  BIN(12) -> '1100'

• See more:
  • MySQL

Issue Links

• blocks: FLINK-6974 Add BIN supported in TableAPI
• links to: GitHub Pull Request #4128