[
https://issues.apache.org/jira/browse/HIVE-26678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Evens Max Pierrelouis resolved HIVE-26678.
-------------------------------------------
Hadoop Flags: Incompatible change,Reviewed
Release Note: About Me I’m Evens max pierrelouis the Chairman of the Board
of Max web TV it’s on Wear TV Edit MB and it is a Haiti BUSINESS for Artificial
Intelligence Deep learning Robotics Enterprise
Tags: MaxwebTVLive
Resolution: Done
"Home
Jarvis AI Assistant management Service for Haiti Business Service Portfolio PBF
& Robots Technology AI Systems Manufactured WEAR-TV
Television Station
WEAR-TV is a television station licensed to Pensacola, Florida, United States,
serving as the ABC affiliate for northwest Florida and southwest Alabama. It is
owned by Sinclair Broadcast Group alongside Fort Walton Beach–licensed
MyNetworkTV affiliate WFGX; Sinclair also provides certain services to Mobile,
Alabama–licensed NBC affiliate WPMI-TV and Pensacola-licensed independent
station WJTC under a local marketing agreement with Deerfield Media Edit Max
WebTV Network Live Streams Production
Broadcasting/Profile/Evensmaxpierrelouis/Inside/menu/Scan me QR Barcode scanner
app Service Job fee is now $500 for every hour of work all services hotline
number Information included and also all job related
too/https://auth-web.moviesanywhere.com?auth-web.moviesanywhere+Haiti Business
Network AI Assistant Satellite internet STB on my tablet Devices Website
Business Customer Service Robotics Connect to the internet on | Connection
Method Wi-Fi | Internet connection status | Mac address (LAN Cable)
01:e2:23:3a:Ab:78 | MAC address (Wi-Fi) | 90:80:b9:e2:38 | SSID
JarvisAIInternet/Internet is/connected f=5785 ec:a9:40:56:be:d0:560 rssi=-46
score=60 tx=1.0,0.0,0 rx=0.8 [(1) {ec;a9:40:56:be:d0*=5785,-4651,7s}] modules:
macro: – key: hello-world-macro function: hello-world-macro-func title: Hello
world macro! description: Inserts hello world! webtrigger: – key:
webtrigger-sync function: my-forge-app-sync-func – key: my-webtrigger-async
function: my-async-func trigger: – key: issue-creation-trigger events: –
avi:jira:created:issue – avi:jira:updated:issue function: issue-trigger-func
jira:workflowValidator: – key: my-forge-workflow-validator name: My example
Forge workflow validator description: The description of my example Forge
workflow validator function: my-forge-validator-function function: – key:
my-forge-app-sync-func handler: index.runSync – key: my-async-func handler:
index.runAsync – key: hello-world-macro-func handler: macro.run – key:
issue-trigger-func handler: jira.issueCreationTrigger – key:
my-forge-validator-function handler: index.runValidate/Wear TV Edit Max WebTV
Network Live Streams Production
Broadcasting/Setting/Account/Evensmaxpierrelouis/Profile/Inside/menu/Scan me QR
Barcode scanner app Service Job fee is now $500/App Store Preview Open the Mac
App Store to buy and download apps. FREECABLE TV: News & TV Shows 17+ 2000+ TV
Channels & Movies MixerBox Inc. Designed for iPad #47 in News 4.7 • 38.7K
Ratings Free iPad Screenshots Additional Screenshots iPhone Description Install
Now for FREE: Stream 2000+ TV shows, movies & breaking news from your phone. TV
app for your phone. Download NOW! ► WORKS LIKE CABLE TV, BUT NO SUBSCRIPTION
NEEDED – FREECABLE TV App provides you with the latest breaking news on
happenings around the globe; as well as, currently airing TV shows, TV series,
movies, sports events, live news all in one app! Download now and start
streaming today"
https://evenspierrelouishpcloud.wordpress.com/about-even-smax-pierrelouis-the-chairman-of-the-board-of-haiti-business-for-artificial-intelligence-deep-leading-robotics-enterprise/#:~:text=learning%20Robotics%C2%A0Enterprise-,Home,news%20all%20in%20one%20app!%20Download%20now%20and%20start%20streaming%20today,-!%20%E2%96%BA%20VARIOUS%20TV%20PROGRAMS
> In the filter criteria associated with multiple tables, the filter result of
> the subquery by not in or in is incorrect.
> -----------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-26678
> URL: https://issues.apache.org/jira/browse/HIVE-26678
> Project: Hive
> Issue Type: Bug
> Components: CBO
> Affects Versions: 3.1.0
> Reporter: lotan
> Priority: Major
>
> create testtable as follow:
> create table test101 (id string,id2 string);
> create table test102 (id string,id2 string);
> create table test103 (id string,id2 string);
> create table test104 (id string,id2 string);
> when cbo is false，run the following SQL statement:
> explain select count(1) from test101 t1
> left join test102 t2 on t1.id=t2.id
> left join test103 t3 on t1.id=t3.id2
> where t1.id in (select s.id from test104 s)
> and t3.id2='123';
> you will see：
> The filter criteria in the right table are lost.
> The execution plan is as follows:
> +-----------------------------------------------------------------------------------------------------+
> | Explain
> |
> +-----------------------------------------------------------------------------------------------------+
> | STAGE DEPENDENCIES:
> |
> | Stage-9 is a root stage
> |
> | Stage-3 depends on stages: Stage-9
> |
> | Stage-0 depends on stages: Stage-3
> |
> |
> |
> | STAGE PLANS:
> |
> | Stage: Stage-9
> |
> | Map Reduce Local Work
> |
> | Alias -> Map Local Tables:
> |
> | sq_1:s
> |
> | Fetch Operator
> |
> | limit: -1
> |
> | t2
> |
> | Fetch Operator
> |
> | limit: -1
> |
> | t3
> |
> | Fetch Operator
> |
> | limit: -1
> |
> | Alias -> Map Local Operator Tree:
> |
> | sq_1:s
> |
> | TableScan
> |
> | alias: s
> |
> | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | Filter Operator
> |
> | predicate: id is not null (type: boolean)
> |
> | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | Select Operator
> |
> | expressions: id (type: string)
> |
> | outputColumnNames: _col0
> |
> | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | Group By Operator
> |
> | keys: _col0 (type: string)
> |
> | mode: hash
> |
> | outputColumnNames: _col0
> |
> | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | HashTable Sink Operator
> |
> | keys:
> |
> | 0 _col0 (type: string)
> |
> | 1 _col0 (type: string)
> |
> | t2
> |
> | TableScan
> |
> | alias: t2
> |
> | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | Filter Operator
> |
> | predicate: id is not null (type: boolean)
> |
> | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | HashTable Sink Operator
> |
> | keys:
> |
> | 0 id (type: string)
> |
> | 1 id (type: string)
> |
> | 2 id2 (type: string)
> |
> | t3
> |
> | TableScan
> |
> | alias: t3
> |
> | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | Filter Operator
> |
> | predicate: id2 is not null (type: boolean)
> |
> | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | HashTable Sink Operator
> |
> | keys:
> |
> | 0 id (type: string)
> |
> | 1 id (type: string)
> |
> | 2 id2 (type: string)
> |
> |
> |
> | Stage: Stage-3
> |
> | Map Reduce
> |
> | Map Operator Tree:
> |
> | TableScan
> |
> | alias: t1
> |
> | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | Filter Operator
> |
> | predicate: id is not null (type: boolean)
> |
> | Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | Map Join Operator
> |
> | condition map:
> |
> | Left Outer Join 0 to 1
> |
> | Left Outer Join 0 to 2
> |
> | keys:
> |
> | 0 id (type: string)
> |
> | 1 id (type: string)
> |
> | 2 id2 (type: string)
> |
> | outputColumnNames: _col0
> |
> | Statistics: Num rows: 2 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | Map Join Operator
> |
> | condition map:
> |
> | Left Semi Join 0 to 1
> |
> | keys:
> |
> | 0 _col0 (type: string)
> |
> | 1 _col0 (type: string)
> |
> | Statistics: Num rows: 2 Data size: 0 Basic stats: PARTIAL
> Column stats: NONE |
> | Group By Operator
> |
> | aggregations: count(1)
> |
> | mode: hash
> |
> | outputColumnNames: _col0
> |
> | Statistics: Num rows: 1 Data size: 8 Basic stats:
> PARTIAL Column stats: NONE |
> | Reduce Output Operator
> |
> | sort order:
> |
> | Statistics: Num rows: 1 Data size: 8 Basic stats:
> PARTIAL Column stats: NONE |
> | value expressions: _col0 (type: bigint)
> |
> | Local Work:
> |
> +-----------------------------------------------------------------------------------------------------+
> | Explain
> |
> +-----------------------------------------------------------------------------------------------------+
> | Map Reduce Local Work
> |
> | Reduce Operator Tree:
> |
> | Group By Operator
> |
> | aggregations: count(VALUE._col0)
> |
> | mode: mergepartial
> |
> | outputColumnNames: _col0
> |
> | Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL Column
> stats: NONE |
> | File Output Operator
> |
> | compressed: false
> |
> | Statistics: Num rows: 1 Data size: 8 Basic stats: PARTIAL
> Column stats: NONE |
> | table:
> |
> | input format:
> org.apache.hadoop.mapred.SequenceFileInputFormat |
> | output format:
> org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
> | serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
> |
> |
> |
> | Stage: Stage-0
> |
> | Fetch Operator
> |
> | limit: -1
> |
> | Processor Tree:
> |
> | ListSink
> |
> |
> |
> +-----------------------------------------------------------------------------------------------------+
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
