2 Replies Latest reply on Oct 2, 2013 4:35 AM by Robert Sutter

    Calculation Error

    Robert Sutter

      I got this error when trying to run a vis:


      Tableau Data Engine Error: 4: HashGrouping::InsertHash: collisions = 580069, size = 58006861, rate = 0.01

       

      Here is the query it was running at the time.I'm not sure if anyone can help me out. Please advise.

       

      (restrict

        (aggregate

          (project

            (table [Extract].[Extract])

            (

              ([none:ADZONE:nk] [ADZONE])

      ([none:AD_LENGTH:nk] [AD_LENGTH])

      ([none:AD_SLOT:nk] [AD_SLOT])

      ([none:CAMPAIGN_LINE_NAME:nk] [CAMPAIGN_LINE_NAME])

      ([none:CAMPAIGN_NAME:nk] [CAMPAIGN_NAME])

      ([none:Calculation_4300906140144890:nk] [Calculation_4300906140144890])

      ([none:Calculation_9270919161656693:nk] [Calculation_9270919161656693])

      ([none:DAYPARTDESCR:nk] [DAYPARTDESCR])

      ([none:EDUCATION:nk] [EDUCATION])

      ([none:ETHNICITY:nk] [ETHNICITY])

      ([none:INCOME:nk] [INCOME])

      ([none:MARKET_NAME:nk] [MARKET_NAME])

      ([none:RATING:nk] [RATING])

      ([twk:START_TIME:ok]

      (to_datetime

      (truncweek [START_TIME])

      )

      )

              ([none:Calculation_7660925085539044:nk]

      (replace [CAMPAIGN_LINE_NAME] "_" " ")

      )

              )

            )

          (

            ([none:AD_SLOT:nk] [none:AD_SLOT:nk])

      ([none:CAMPAIGN_LINE_NAME:nk] [none:CAMPAIGN_LINE_NAME:nk])

            ([none:Calculation_7660925085539044:nk] [none:Calculation_7660925085539044:nk])

            )

          (

      ([TEMP(Calculation_6220906115413468)(1898783388)(0)]

              (count [CPM])

              )

      ([TEMP(Calculation_6220906115413468)(2766255973)(0)]

              (sum [CPM])

              )

      ([TEMP(Calculation_6220906115413468)(3857851743)(0)]

              (sum [IMPRESSION])

              )

      ([TEMP(Calculation_6290917132018862)(3518017574)(0)]

              (min [CPM])

              )

      ([TEMP(Calculation_6290917132018862)(3857851743)(0)]

              (sum [IMPRESSION])

              )

      ([TEMP(Calculation_6290917132018862)(4267700718)(0)]

              (sum [IMPRESSION])

              )

            ([ctd:HH_ID:qk]

              (countd [HH_ID])

              )

            ([min:CPM:qk]

              (min [CPM])

              )

            ([sum:DECISION:qk]

              (sum [DECISION])

              )

            ([sum:IMPRESSION:qk]

              (sum [IMPRESSION])

              )

            )

          )

        ([none:AD_SLOT:nk] [none:CAMPAIGN_LINE_NAME:nk] [none:Calculation_7660925085539044:nk] [TEMP(Calculation_6220906115413468)(1898783388)(0)] [TEMP(Calculation_6220906115413468)(2766255973)(0)] [TEMP(Calculation_6220906115413468)(3857851743)(0)] [TEMP(Calculation_6290917132018862)(3518017574)(0)] [TEMP(Calculation_6290917132018862)(3857851743)(0)] [TEMP(Calculation_6290917132018862)(4267700718)(0)] [ctd:HH_ID:qk] [min:CPM:qk] [sum:DECISION:qk] [sum:IMPRESSION:qk])

        )