[
https://issues.apache.org/jira/browse/CASSANDRA-10881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sandeep Gopalasetty reopened CASSANDRA-10881:
---------------------------------------------
Hi Carl,
If there is no support for joining data from multiple source table means, in
real time projects we definitely require this case. Is there any kind of
alternative carl?
My Schemas:
Table 1. CREATE TABLE courses(code TEXT,description TEXT,days INT,PRIMARY KEY
(code, description,days));
Values:
INSERT INTO courses(code, description, days) VALUES ('SQL','SQL course',45);
INSERT INTO courses(code, description, days) VALUES ('OAU','Oracle course',45);
INSERT INTO courses(code, description, days) VALUES ('JAV','Java course',90);
INSERT INTO courses(code, description, days) VALUES ('PLS','plsql course',30);
INSERT INTO courses(code, description, days) VALUES ('SAP','SAP course',90);
INSERT INTO courses(code, description, days) VALUES ('DNT','dotnet course',60);
INSERT INTO courses(code, description, days) VALUES ('NWS','Networks
course',45);
INSERT INTO courses(code, description, days) VALUES ('CLC','Cloud computing
course',40);
Table 2. CREATE TABLE courseschedule(course TEXT,trainer TEXT,location
TEXT,PRIMARY KEY (course,trainer));
Values:
INSERT INTO courseschedule(course, trainer, location) VALUES ('SQL','Satish
Mongam','Mind Space HYD');
INSERT INTO courseschedule(course, trainer, location) VALUES ('OAU','Vinay
Raj','Cyber Gateway HYD');
INSERT INTO courseschedule(course, trainer, location) VALUES ('JAV','Ravi
Nallani','Cyber Towers HYD');
INSERT INTO courseschedule(course, trainer, location) VALUES ('PLS','Srikar
Gondesi','Maitrivanam HYD');
INSERT INTO courseschedule(course, trainer, location) VALUES ('SAP','Devi
Prasad Reddy','SAP Labs BLR');
INSERT INTO courseschedule(course, trainer, location) VALUES ('DNT','Rohit
Kotni','White field BLR');
INSERT INTO courseschedule(course, trainer, location) VALUES ('NWS','Kiran
Mammuluri','EON IT PUN');
INSERT INTO courseschedule(course, trainer, location) VALUES ('CLC','Viraaj
Patel','AD Labs HYD');
I want a materialized view as "Job Training". It should retrieve as
code,description,days from Table "courses" and trainer from "courseschedule"
WHERE code from courses = course from courseschedule. This view should be
created, as it is from two different tables. Is there any specific syntax? We
are unable to create this, could you please help.
> Unable to create a materialized view for retrieving the data from two
> different tables.
> ---------------------------------------------------------------------------------------
>
> Key: CASSANDRA-10881
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10881
> Project: Cassandra
> Issue Type: Bug
> Components: CQL
> Environment: Windows
> Reporter: Sandeep Gopalasetty
> Priority: Critical
>
> Unable to create a materialized views for retrieving the data from two
> different tables. Syntactical problems are been arising. Is there any
> specific syntax?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
