[jira] (PHOENIX-792) Support UPSERT SET command

2022-10-26 Thread Lars Hofhansl (Jira)


[ https://issues.apache.org/jira/browse/PHOENIX-792 ]


Lars Hofhansl deleted comment on PHOENIX-792:
---

was (Author: JIRAUSER297473):
Informative, for more info visit this [Blog|https://techlarapoint.com/].

> Support UPSERT SET command
> --
>
> Key: PHOENIX-792
> URL: https://issues.apache.org/jira/browse/PHOENIX-792
> Project: Phoenix
>  Issue Type: Task
>Reporter: James R. Taylor
>Assignee: thrylokya
>
> Support setting values in a table through a new UPSERT SET command like this:
> UPSERT my_table SET title = 'CEO'
> WHERE name = 'John Doe'
> UPSERT my_table SET pay_by_quarter = ARRAY[25000,25000,27000,27000]
> WHERE name = 'Carol';
> UPSERT my_table SET pay_by_quarter[4] = 15000
> WHERE name = 'Carol';
> This would essentially be syntactic sugar and use the same UpsertCompiler, 
> mapping to an UPSERT SELECT command that simply fills in the primary key 
> columns like this:
> UPSERT FROM my_table(name,title) 
> SELECT name,'CEO' FROM my_table
> WHERE name = 'John Doe'
> UPSERT FROM my_table(name, pay_by_quarter[4]) 
> SELECT name,15000 FROM my_table
> WHERE name = 'Carol';



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Commented] (PHOENIX-6784) PhantomJS fails on recent Linux distributions

2022-10-26 Thread ASF GitHub Bot (Jira)


[ 
https://issues.apache.org/jira/browse/PHOENIX-6784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17624301#comment-17624301
 ] 

ASF GitHub Bot commented on PHOENIX-6784:
-

stoty closed pull request #1521: PHOENIX-6784 PhantomJS fails on recent Linux 
distributions
URL: https://github.com/apache/phoenix/pull/1521




> PhantomJS fails on recent Linux distributions
> -
>
> Key: PHOENIX-6784
> URL: https://issues.apache.org/jira/browse/PHOENIX-6784
> Project: Phoenix
>  Issue Type: Bug
>Reporter: Istvan Toth
>Assignee: Istvan Toth
>Priority: Blocker
>
> PhantomJS cannot run on recent linux distributions, like Ubuntu 22.04.
> I've found the following explanation and fix:
> [https://stackoverflow.com/questions/73004195/phantomjs-wont-install-autoconfiguration-error]
> Apply the _export OPENSSL_CONF=/dev/null_  fix to the build.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[GitHub] [phoenix] stoty closed pull request #1521: PHOENIX-6784 PhantomJS fails on recent Linux distributions

2022-10-26 Thread GitBox


stoty closed pull request #1521: PHOENIX-6784 PhantomJS fails on recent Linux 
distributions
URL: https://github.com/apache/phoenix/pull/1521


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscr...@phoenix.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org