Re: Null array elements with joins

2018-08-27 Thread Gerald Sangudi
Hi folks, I submitted PR https://github.com/apache/phoenix/pull/335 Appreciate your review. Thanks, Gerald On Mon, Aug 13, 2018 at 1:10 PM, James Taylor wrote: > I commented on the JIRA you filed here: PHOENIX-4791. Best to keep > discussion there. > Thanks, > James > > On Mon, Aug 13, 2018 a

Re: Null array elements with joins

2018-08-13 Thread James Taylor
I commented on the JIRA you filed here: PHOENIX-4791. Best to keep discussion there. Thanks, James On Mon, Aug 13, 2018 at 11:08 AM, Gerald Sangudi wrote: > Hello all, > > Any suggestions or pointers on the issue below? > > Projecting array elements works when not using joins, and does not work

Re: Null array elements with joins

2018-08-13 Thread Gerald Sangudi
Hello all, Any suggestions or pointers on the issue below? Projecting array elements works when not using joins, and does not work when we use hash joins. Is there an issue with the ProjectionCompiler for joins? I have not been able to isolate the specific cause, and would appreciate any pointers

Null array elements with joins

2018-06-19 Thread Tulasi Paradarami
Hi, I'm running few tests against Phoenix array and running into this bug where array elements return null values when a join is involved. Is this a known issue/limitation of arrays? create table array_test_1 (id integer not null primary key, arr tinyint[5]); upsert into array_test_1 values (1001