Skip to Main Content

Data Science & Machine Learning

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

oracle data miner bug or error programming?

3558648Sep 28 2017 — edited Sep 28 2017

good morning, see if you can help me. I'm using sql developer,and oracle data miner, and I have observed, as the sql code doubles, and the execution lasts twice as long,I send you the images and the code that is repeated, this does not happen to me alone, but also to my colleagues.please can you help me. Very thanks

captura odm1.jpg

the code that repeats begins on line 06 up to 48(/* Start of sql for node: CUSTOMER */)then starts at 68 to 110

/* SQL Deployed by Oracle SQL Developer 4.1.2.20.64 from Node "Join", Workflow "dhf", Project "bigdatalite", Connection "moviedemo" on Sep 27, 2017 */

ALTER SESSION set "_optimizer_reuse_cost_annotations" = false;

ALTER SESSION set NLS_NUMERIC_CHARACTERS = ".," ;

--ALTER SESSION FOR OPTIMIZER

WITH

/* Start of sql for node: CUSTOMER */

"N$10001" as (select "CUSTOMER"."AGE",

"CUSTOMER"."CITY",

"CUSTOMER"."CITY_ID",

"CUSTOMER"."COMMUTE_DISTANCE",

"CUSTOMER"."COUNTRY",

"CUSTOMER"."COUNTRY_CODE",

"CUSTOMER"."COUNTRY_ID",

"CUSTOMER"."CREDIT_BALANCE",

"CUSTOMER"."CUST_ID",

"CUSTOMER"."EDUCATION",

"CUSTOMER"."EMAIL",

"CUSTOMER"."FIRST_NAME",

"CUSTOMER"."FULL_TIME",

"CUSTOMER"."GENDER",

"CUSTOMER"."HOUSEHOLD_SIZE",

"CUSTOMER"."INCOME",

"CUSTOMER"."INCOME_LEVEL",

"CUSTOMER"."INSUFF_FUNDS_INCIDENTS",

"CUSTOMER"."JOB_TYPE",

"CUSTOMER"."LAST_NAME",

"CUSTOMER"."LATE_MORT_RENT_PMTS",

"CUSTOMER"."MARITAL_STATUS",

"CUSTOMER"."MORTGAGE_AMT",

"CUSTOMER"."NUM_CARS",

"CUSTOMER"."NUM_MORTGAGES",

"CUSTOMER"."PET",

"CUSTOMER"."POSTAL_CODE",

"CUSTOMER"."PROMOTION_RESPONSE",

"CUSTOMER"."RENT_OWN",

"CUSTOMER"."SEG",

"CUSTOMER"."STATE_PROVINCE",

"CUSTOMER"."STATE_PROVINCE_ID",

"CUSTOMER"."STREET_ADDRESS",

"CUSTOMER"."USERNAME",

"CUSTOMER"."WORK_EXPERIENCE",

"CUSTOMER"."YRS_CURRENT_EMPLOYER",

"CUSTOMER"."YRS_CUSTOMER",

"CUSTOMER"."YRS_RESIDENCE",

"CUSTOMER"."CONTINENT",

"CUSTOMER"."CONTINENT_ID"

from "MOVIEDEMO"."CUSTOMER" )

/* End of sql for node: CUSTOMER */

,

/* Start of sql for node: SQL Query */

"CUSTOMER_N$10001" as (SELECT * FROM "N$10001"),

"N$10002" as (SELECT

"CUSTOMER_N$10001"."AGE",

"CUSTOMER_N$10001"."CITY",

"CUSTOMER_N$10001"."CITY_ID",

"CUSTOMER_N$10001"."COMMUTE_DISTANCE"

FROM "CUSTOMER_N$10001")

/* End of sql for node: SQL Query */

,

/* Start of sql for node: SQL Query 1 */

"SQL Query_N$10002" as (SELECT * FROM "N$10002"),

"N$10004" as (SELECT "SQL Query_N$10002"."AGE",

"SQL Query_N$10002"."CITY",

"SQL Query_N$10002"."CITY_ID"

FROM "SQL Query_N$10002")

/* End of sql for node: SQL Query 1 */

,

/* Start of sql for node: CUSTOMER */

"N$10001" as (select "CUSTOMER"."AGE",

"CUSTOMER"."CITY",

"CUSTOMER"."CITY_ID",

"CUSTOMER"."COMMUTE_DISTANCE",

"CUSTOMER"."COUNTRY",

"CUSTOMER"."COUNTRY_CODE",

"CUSTOMER"."COUNTRY_ID",

"CUSTOMER"."CREDIT_BALANCE",

"CUSTOMER"."CUST_ID",

"CUSTOMER"."EDUCATION",

"CUSTOMER"."EMAIL",

"CUSTOMER"."FIRST_NAME",

"CUSTOMER"."FULL_TIME",

"CUSTOMER"."GENDER",

"CUSTOMER"."HOUSEHOLD_SIZE",

"CUSTOMER"."INCOME",

"CUSTOMER"."INCOME_LEVEL",

"CUSTOMER"."INSUFF_FUNDS_INCIDENTS",

"CUSTOMER"."JOB_TYPE",

"CUSTOMER"."LAST_NAME",

"CUSTOMER"."LATE_MORT_RENT_PMTS",

"CUSTOMER"."MARITAL_STATUS",

"CUSTOMER"."MORTGAGE_AMT",

"CUSTOMER"."NUM_CARS",

"CUSTOMER"."NUM_MORTGAGES",

"CUSTOMER"."PET",

"CUSTOMER"."POSTAL_CODE",

"CUSTOMER"."PROMOTION_RESPONSE",

"CUSTOMER"."RENT_OWN",

"CUSTOMER"."SEG",

"CUSTOMER"."STATE_PROVINCE",

"CUSTOMER"."STATE_PROVINCE_ID",

"CUSTOMER"."STREET_ADDRESS",

"CUSTOMER"."USERNAME",

"CUSTOMER"."WORK_EXPERIENCE",

"CUSTOMER"."YRS_CURRENT_EMPLOYER",

"CUSTOMER"."YRS_CUSTOMER",

"CUSTOMER"."YRS_RESIDENCE",

"CUSTOMER"."CONTINENT",

"CUSTOMER"."CONTINENT_ID"

from "MOVIEDEMO"."CUSTOMER" )

/* End of sql for node: CUSTOMER */

,

/* Start of sql for node: SQL Query */

"CUSTOMER_N$10001" as (SELECT * FROM "N$10001"),

"N$10002" as (SELECT

"CUSTOMER_N$10001"."AGE",

"CUSTOMER_N$10001"."CITY",

"CUSTOMER_N$10001"."CITY_ID",

"CUSTOMER_N$10001"."COMMUTE_DISTANCE"

FROM "CUSTOMER_N$10001")

/* End of sql for node: SQL Query */

,

/* Start of sql for node: Join */

"N$10003" as (SELECT

"SQL Query"."AGE"

, "SQL Query"."CITY"

, "SQL Query"."CITY_ID"

, "SQL Query"."COMMUTE_DISTANCE"

, "SQL Query 1"."AGE" "AGE1"

, "SQL Query 1"."CITY" "CITY1"

, "SQL Query 1"."CITY_ID" "CITY_ID1"

FROM

"N$10002" "SQL Query"

LEFT OUTER JOIN "N$10004" "SQL Query 1"

ON "SQL Query"."AGE" = "SQL Query 1"."AGE"

)

/* End of sql for node: Join */

select * from "N$10003";

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 26 2017
Added on Sep 28 2017
0 comments
433 views