[jira] [Commented] (CASSANDRA-10881) Unable to create a materialized view for retrieving the data from two different tables.

["Sandeep Gopalasetty (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-10881?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15060427#comment-15060427 ] 

Sandeep Gopalasetty commented on 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)