[PHOENIX-1664] Implement missing binary string built-in functions

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: Java gsoc2015 mentor sql
• Assignee: Unassigned
• Reporter: James R. Taylor
• Created: 14/Feb/15 06:24
• Updated: 24/Jan/16 02:58

Description

Take a look at the typical binary string functions and bit string operators that are implemented in relational database systems (http://www.postgresql.org/docs/8.1/static/functions-binarystring.html and http://www.postgresql.org/docs/8.1/static/functions-bitstring.html) and implement the same for Phoenix in Java following this guide: http://phoenix-hbase.blogspot.com/2013/04/how-to-add-your-own-built-in-function.html

Examples of missing functions include GET_BYTE, SET_BYTE, GET_BIT, SET_BIT, etc and missing operators include &, |, #, ~, <<, and >>. As a guide, examine how ROUND is implemented in Phoenix as an abstract function with concrete functions per type: long, decimal, and date/time types, as many of the existing built-in functions are already defined but are not applicable for binary types.

Issue Links

• is a clone of: PHOENIX-1660 Implement missing math built-in functions
• is cloned by: PHOENIX-1665 Implement missing ARRAY built-in functions

Sub-Tasks

• Implement get_byte/set_byte/get_bit/set_bit Binary String build-in function: Closed
• Implement octet_length build-in function for BINARY and VARBINARY: Closed
• Implement position/substring/trim built-in function for BINARY VARBINARY: Open
• Implement trimb built-in function for BINARY and VARBINARY: Patch Available