Forum Stats

  • 3,727,350 Users
  • 2,245,373 Discussions
  • 7,852,750 Comments

Discussions

oracle data miner bug or error programming?

3558648
3558648 Member Posts: 1
edited September 2017 in Machine Learning

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 OPTIMIZERWITH /* 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";
Tagged:
This discussion has been closed.