Re: Unexpected dynamic column issues

2017-04-07 Thread Samarth Jain
Actually, this is expected behavior with the new column mapping/encoding feature. With column mapping enabled, Phoenix now uses a different qualifier than the one derived directly from the column name. For a column mapped table, when you use a dynamic column here upsert into TMP_SNACKS(k, c1, "pag

Re: UDF doesn't work with Sort Merge Join Hint

2017-04-07 Thread rajeshb...@apache.org
It's a bug and already fixed https://issues.apache.org/jira/browse/PHOENIX-2841. On Fri, Apr 7, 2017 at 1:18 PM, Bernard Quizon < bernard.qui...@stellarloyalty.com> wrote: > HI, > > I'm using Phoenix-4.4-hbase-1.1 and whenever I run a statement that has a > UDF in the SELECT clause with the sort

UDF doesn't work with Sort Merge Join Hint

2017-04-07 Thread Bernard Quizon
HI, I'm using Phoenix-4.4-hbase-1.1 and whenever I run a statement that has a UDF in the SELECT clause with the sort merge join hint, it results to the error function undefined. Sample: SELECT /*+ USE_SORT_MERGE_JOIN */ my_udf(test_column) as udf FROM table1 a INNER JOIN table2 b on a.id = b.id