redis集群支持交易吗?(does redis cluster support transactions ?)
我是redis的新手,我刚刚使用redis几个月。 目前我使用的是2.8.x稳定版,但我正在尝试使用3.0.0导入redis集群功能。 我使用java jedis作为客户端,这是我的问题:我发现最新版本的Jedis客户端支持redis集群lua脚本(JedisCluster.evalsha),但我无处可寻找管道和事务相关的函数,所以我想知道如果Jedis还没有实现它(管道,事务)还是只是redis集群根本不支持流水线和事务处理?
i'm a newbie for redis, i've just been using redis for couple of months. Currently i'm using 2.8.x stable version but i'm trying to use 3.0.0 to import redis cluster funtions. i'm using java jedis as client,and here is my problem:i found that the latest version of Jedis client support redis cluster lua scripting(JedisCluster.evalsha), but nowhere i can find pipelining and transaction related functions, so i was wondering if it is Jedis that have not implement it(pipeline, transactions) yet or is it just redis cluster does not support pipelining and transactions at all?
原文:https://stackoverflow.com/questions/30771265
满意答案
避免使用旧式连接。 因为enddate和startdate来自pettreatment表,并且您已经从中进行选择,所以您只需在
where
子句中指定条件即可。 无需选择。SELECT P.PETNAME,P.PETTYPE FROM PETTREATMENT PT JOIN EXAMINATION E ON PT.EXAMNO = E.EXAMNO JOIN PET P ON E.PETNO = P.PETNO JOIN TREATMENT T ON PT.TREATNO = T.TREATNO WHERE TO_DATE(PT.ENDDATE,'DD-MON-YYYY') - TO_DATE(PT.STARTDATE,'DD-MON-YYYY') > 2 AND T.COST > 100 ORDER BY P.PETNAME;
Avoid using old-style joins. Because enddate and startdate come from pettreatment table, and you are already selecting from it, you can just specify the condition in the
where
clause. No need for a select.SELECT P.PETNAME,P.PETTYPE FROM PETTREATMENT PT JOIN EXAMINATION E ON PT.EXAMNO = E.EXAMNO JOIN PET P ON E.PETNO = P.PETNO JOIN TREATMENT T ON PT.TREATNO = T.TREATNO WHERE TO_DATE(PT.ENDDATE,'DD-MON-YYYY') - TO_DATE(PT.STARTDATE,'DD-MON-YYYY') > 2 AND T.COST > 100 ORDER BY P.PETNAME;
相关问答
更多ORACLE中SQLPlus的用法
Oracle ORA-00936子查询缺少表达式错误(Oracle ORA-00936 Missing Expression Error with Subquery)
Oracle,确定value是否为null(Oracle, determine if value is null)
日期查询在sqlplus和oracle sql developer中给出了两个结果(Date query giving two results in sqlplus & oracle sql developer)
无法在OVM VIrtualBox上使用Oracle Developer日期连接sqlplus hr / hr(Can't connect sqlplus hr/hr using Oracle Developer days on OVM VIrtualBox)
Oracle 11g - 运行windows批处理文件在sqlplus中运行多个sql文件(Oracle 11g - run windows batch file to run multiple sql files in sqlplus)
SQLPLUS(Oracle) - WHERE子查询,用于确定日期表达式是否大于n天(SQLPLUS (Oracle) - WHERE subquery to determine if date expression greater than n Days)
使用SQL减去日期的n天(Subtracting n Days from a date using SQL)
Oracle DB sqlplus问题[关闭](Oracle DB sqlplus issue [closed])
Oracle中的日期表达式(Date expression in Oracle)
相关文章
更多redis 集群环境搭建-redis集群管理
redis新增集群节点-redis集群管理
redis集群插槽分配-redis集群管理
redis删除集群节点-redis集群管理
redis集群出现宕机没法访问-redis集群管理
redis 集群使用主从复制架构-redis集群管理
redis安装-redis集群管理
Redis 事务详解
Spark - A Fault-Tolerant Abstraction for In-Memory Cluster Computing
Redis概述
最新问答
更多获取MVC 4使用的DisplayMode后缀(Get the DisplayMode Suffix being used by MVC 4)
如何通过引用返回对象?(How is returning an object by reference possible?)
矩阵如何存储在内存中?(How are matrices stored in memory?)
每个请求的Java新会话?(Java New Session For Each Request?)
css:浮动div中重叠的标题h1(css: overlapping headlines h1 in floated divs)
无论图像如何,Caffe预测同一类(Caffe predicts same class regardless of image)
xcode语法颜色编码解释?(xcode syntax color coding explained?)
在Access 2010 Runtime中使用Office 2000校对工具(Use Office 2000 proofing tools in Access 2010 Runtime)
从单独的Web主机将图像传输到服务器上(Getting images onto server from separate web host)
从旧版本复制文件并保留它们(旧/新版本)(Copy a file from old revision and keep both of them (old / new revision))
Copyright ©2023 peixunduo.com All Rights Reserved.粤ICP备14003112号
本站部分内容来源于互联网,仅供学习和参考使用,请莫用于商业用途。如有侵犯你的版权,请联系我们(neng862121861#163.com),本站将尽快处理。谢谢合作!