[
https://issues.apache.org/jira/browse/CASSANDRA-10881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15060724#comment-15060724
]
Sandeep Gopalasetty commented on CASSANDRA-10881:
-------------------------------------------------
Hi Carl,
we were unable to create a materialized view for retrieving the data
from two different tables.
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.
--
Thanks & Regards,
Sandeep Gopalasetty
IIB Developer
Miracle Software Systems,Inc
Email : [email protected]
Work : 1-248-233-1889
Mobile: 91-9966991134
______________________________________________________________________
This email has been scanned by the Symantec Email Security.
______________________________________________________________________
> 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)
