Re: Bulk csv data insertion to phoenix table for dynamic columns

2015-05-08 Thread Nicolas Maillard
Hey The problem with dynamic columns is that the syntax is not sql compliant, sorry about that, way back then it slipped. Nicolas Maillard Solutions Engineer - EMEA +33 (0) 668176605| Skype: nicolas.maillard.hortonworks From:

Bulk csv data insertion to phoenix table for dynamic columns

2015-05-08 Thread sayan . chakrabarti
Hi Team, Bulk csv data uploading (http://phoenix.apache.org/bulk_dataload.html#) works fine. My question is how to insert to the dynamic columns using psql.py command. I tried my best but didn't get any clue. Let me elaborate, If some columns of the csv files are dynamic column ( not static

[jira] [Updated] (PHOENIX-1875) implement ARRAY_PREPEND built in function

2015-05-08 Thread Dumindu Buddhika (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dumindu Buddhika updated PHOENIX-1875: -- Attachment: PHOENIX-1875-v5.patch Comment added to explain logic. implement

[jira] [Created] (PHOENIX-1957) Syntax error in DOAP file release section

2015-05-08 Thread Sebb (JIRA)
Sebb created PHOENIX-1957: - Summary: Syntax error in DOAP file release section Key: PHOENIX-1957 URL: https://issues.apache.org/jira/browse/PHOENIX-1957 Project: Phoenix Issue Type: Bug

[jira] [Commented] (PHOENIX-1875) implement ARRAY_PREPEND built in function

2015-05-08 Thread ramkrishna.s.vasudevan (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14534744#comment-14534744 ] ramkrishna.s.vasudevan commented on PHOENIX-1875: - +1. Let's wait for

[jira] [Commented] (PHOENIX-1948) bin scripts run under make_rc.sh packaging

2015-05-08 Thread Nick Dimiduk (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14534857#comment-14534857 ] Nick Dimiduk commented on PHOENIX-1948: --- From the same thread, Sergey confirms

[jira] [Updated] (PHOENIX-1956) SELECT (FALSE OR FALSE) RETURNS TRUE

2015-05-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1956: -- Attachment: PHOENIX-1956.patch Good find, [~rajeshbabu]. Here's a patch. SELECT (FALSE OR

[jira] [Commented] (PHOENIX-1958) Minimize memory allocation on new connection

2015-05-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1958?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14535101#comment-14535101 ] James Taylor commented on PHOENIX-1958: --- [~rajeshbabu] - I'll try to put a patch

[jira] [Updated] (PHOENIX-1958) Minimize memory allocation on new connection

2015-05-08 Thread Rajeshbabu Chintaguntla (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajeshbabu Chintaguntla updated PHOENIX-1958: - Fix Version/s: 4.4.0 5.0.0 Minimize memory

[jira] [Commented] (PHOENIX-1956) SELECT (FALSE OR FALSE) RETURNS TRUE

2015-05-08 Thread Rajeshbabu Chintaguntla (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14535086#comment-14535086 ] Rajeshbabu Chintaguntla commented on PHOENIX-1956: -- [~jamestaylor] I am

[jira] [Commented] (PHOENIX-1948) bin scripts run under make_rc.sh packaging

2015-05-08 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14535351#comment-14535351 ] Hudson commented on PHOENIX-1948: - SUCCESS: Integrated in Phoenix-master #745 (See

[jira] [Updated] (PHOENIX-1959) Windows is getting stuck on test testUpsertSelectDoesntSeeUpsertedData

2015-05-08 Thread Alicia Ying Shu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alicia Ying Shu updated PHOENIX-1959: - Description: Several tests are failing with SequenceNotFoundException error Windows is

[jira] [Updated] (PHOENIX-1959) Windows is getting stuck on test testUpsertSelectDoesntSeeUpsertedData

2015-05-08 Thread Alicia Ying Shu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alicia Ying Shu updated PHOENIX-1959: - Description: Several tests were failing with SequenceNotFoundException error (was:

[jira] [Updated] (PHOENIX-1959) Windows is getting stuck on test testUpsertSelectDoesntSeeUpsertedData

2015-05-08 Thread Alicia Ying Shu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alicia Ying Shu updated PHOENIX-1959: - Attachment: Phoenix-1959.patch Windows is getting stuck on test

[jira] [Commented] (PHOENIX-1959) Windows is getting stuck on test testUpsertSelectDoesntSeeUpsertedData

2015-05-08 Thread Alicia Ying Shu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14535606#comment-14535606 ] Alicia Ying Shu commented on PHOENIX-1959: -- Uploaded a patch. Windows is

[jira] [Commented] (PHOENIX-1948) bin scripts run under make_rc.sh packaging

2015-05-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1948?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14535200#comment-14535200 ] James Taylor commented on PHOENIX-1948: --- +1 from me too. bin scripts run under

[jira] [Commented] (PHOENIX-1956) SELECT (FALSE OR FALSE) RETURNS TRUE

2015-05-08 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14535522#comment-14535522 ] Hudson commented on PHOENIX-1956: - SUCCESS: Integrated in Phoenix-master #746 (See

[jira] [Commented] (PHOENIX-1960) Pherf unit tests failing

2015-05-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1960?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14535601#comment-14535601 ] James Taylor commented on PHOENIX-1960: --- [~cody.mar...@gmail.com] - would you have

[jira] [Created] (PHOENIX-1960) Pherf unit tests failing

2015-05-08 Thread James Taylor (JIRA)
James Taylor created PHOENIX-1960: - Summary: Pherf unit tests failing Key: PHOENIX-1960 URL: https://issues.apache.org/jira/browse/PHOENIX-1960 Project: Phoenix Issue Type: Bug

[jira] [Created] (PHOENIX-1956) SELECT (FALSE OR FALSE) RETURNS TRUE

2015-05-08 Thread Rajeshbabu Chintaguntla (JIRA)
Rajeshbabu Chintaguntla created PHOENIX-1956: Summary: SELECT (FALSE OR FALSE) RETURNS TRUE Key: PHOENIX-1956 URL: https://issues.apache.org/jira/browse/PHOENIX-1956 Project: Phoenix

[jira] [Updated] (PHOENIX-1958) Minimize memory allocation on new connection

2015-05-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor updated PHOENIX-1958: -- Attachment: PHOENIX-1958.patch Minimize memory allocation on new connection

[jira] [Resolved] (PHOENIX-1956) SELECT (FALSE OR FALSE) RETURNS TRUE

2015-05-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James Taylor resolved PHOENIX-1956. --- Resolution: Fixed SELECT (FALSE OR FALSE) RETURNS TRUE

[jira] [Commented] (PHOENIX-1959) Windows is getting stuck on test testUpsertSelectDoesntSeeUpsertedData

2015-05-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14535659#comment-14535659 ] James Taylor commented on PHOENIX-1959: --- -1. This code was removed and moved

[jira] [Created] (PHOENIX-1961) Tenant-specific View TTLs

2015-05-08 Thread Eli Levine (JIRA)
Eli Levine created PHOENIX-1961: --- Summary: Tenant-specific View TTLs Key: PHOENIX-1961 URL: https://issues.apache.org/jira/browse/PHOENIX-1961 Project: Phoenix Issue Type: Bug

[jira] [Commented] (PHOENIX-1962) Apply check style to the build

2015-05-08 Thread James Taylor (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14536237#comment-14536237 ] James Taylor commented on PHOENIX-1962: --- Awesome, [~ndimiduk] - thanks for picking

[jira] [Created] (PHOENIX-1962) Apply check style to the build

2015-05-08 Thread Nick Dimiduk (JIRA)
Nick Dimiduk created PHOENIX-1962: - Summary: Apply check style to the build Key: PHOENIX-1962 URL: https://issues.apache.org/jira/browse/PHOENIX-1962 Project: Phoenix Issue Type: Task

[jira] [Updated] (PHOENIX-1962) Apply check style to the build

2015-05-08 Thread Nick Dimiduk (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Nick Dimiduk updated PHOENIX-1962: -- Attachment: PHOENIX-1962.00.patch Caltrain patch! This is mostly copied over from Calcite's

[jira] [Commented] (PHOENIX-1953) Sub Query do bot work for *(all column)

2015-05-08 Thread Nick Hryhoriev (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14534397#comment-14534397 ] Nick Hryhoriev commented on PHOENIX-1953: - You write that Phoenix-1953 is

[jira] [Commented] (PHOENIX-1959) Windows is getting stuck on test testUpsertSelectDoesntSeeUpsertedData

2015-05-08 Thread Alicia Ying Shu (JIRA)
[ https://issues.apache.org/jira/browse/PHOENIX-1959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14536041#comment-14536041 ] Alicia Ying Shu commented on PHOENIX-1959: -- Do you have the Jira#? Thanks.