Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

impala odbc + tableau

Highlighted

impala odbc + tableau

New Contributor
Hi, guys)
I have a problem with the cloudera impala(CDH 5.2).
 
 
cloudera impala odbc driver 2.5.2
tableau desktop 8.2
impala 2.0
 
Report a Tableau was showing this error:
 
[Cloudera][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : IllegalStateException: Illegal reference to non-materialized tuple: tid=4
 
Сan you explain why?
3 REPLIES 3

Re: impala odbc tableau

Contributor
This looks like an issue in Impala. Can you provide the query that was run
when this happened? You can find the
query in the debug webpage of the impalad the query was sent to (or the
impalad INFO log for that machine).

Highlighted

Re: impala odbc tableau

New Contributor

Thanks for the reply, Nong!

 

SELECT `custom_sql_query`.`city` AS `none_city_nk`,
  `custom_sql_query`.`date_dt`   AS `none_date_dt_ok`,
  `custom_sql_query`.`isp`       AS `none_isp_nk`,
  AVG((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `avg_calculation_5120823120155293_ok`
FROM
  (SELECT `f_wot_network_quality_ipr_agg`.`dt`         AS `dt`,
    `f_wot_network_quality_ipr_agg`.`batch_count`      AS `batch_count`,
    `f_wot_network_quality_ipr_agg`.`city`             AS `city`,
    `f_wot_network_quality_ipr_agg`.`region`           AS `region`,
    `f_wot_network_quality_ipr_agg`.`delay`            AS `delay`,
    `f_wot_network_quality_ipr_agg`.`fromip`           AS `fromip`,
    `f_wot_network_quality_ipr_agg`.`isp`              AS `isp`,
    `f_wot_network_quality_ipr_agg`.`packets_received` AS `packets_received`,
    `f_wot_network_quality_ipr_agg`.`packets_sent`     AS `packets_sent`,
    `f_wot_network_quality_ipr_agg`.`packets_resent`   AS `packets_resent`,
    `f_wot_network_quality_ipr_agg`.`date_dt`          AS `date_dt`,
    `f_wot_network_quality_ipr_agg`.`toip`             AS `toip`,
    `d_peripheries`.`periphery_id`                     AS `periphery_id`,
    `dim_countries`.`country_name`                     AS `country_name`
  FROM `dw_pr`.`f_wot_network_quality_ipr_agg` `f_wot_network_quality_ipr_agg`
  JOIN `dw_pr`.`d_peripheries` `d_peripheries`
  ON (`f_wot_network_quality_ipr_agg`.`periphery_nkey` = `d_peripheries`.`periphery_nkey`)
  JOIN `dw_pr`.`dim_countries` `dim_countries`
  ON (`f_wot_network_quality_ipr_agg`.`country_code_3_letter` = `dim_countries`.`country_code_3_letter`)
  WHERE `periphery_id`                                        =6
  AND `dt`                                                    > days_add(CURRENT_TIMESTAMP(),-1)
  ) `custom_sql_query`
WHERE false
GROUP BY 1,
  2,
  3
  ---



SELECT `custom_sql_query`.`fromip`      AS `none_fromip_nk`,
  `custom_sql_query`.`toip`             AS `none_toip_nk`,
  SUM(`custom_sql_query`.`batch_count`) AS `temp_tc___2391220405__0_`,
  AVG((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `avg_calculation_5120823120155293_ok`,
  COUNT((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `cnt_calculation_5120823120155293_ok`,
  SUM((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `sum_calculation_5120823120155293_ok`
FROM
  (SELECT `f_wot_network_quality_ipr_agg`.`dt`         AS `dt`,
    `f_wot_network_quality_ipr_agg`.`batch_count`      AS `batch_count`,
    `f_wot_network_quality_ipr_agg`.`city`             AS `city`,
    `f_wot_network_quality_ipr_agg`.`region`           AS `region`,
    `f_wot_network_quality_ipr_agg`.`delay`            AS `delay`,
    `f_wot_network_quality_ipr_agg`.`fromip`           AS `fromip`,
    `f_wot_network_quality_ipr_agg`.`isp`              AS `isp`,
    `f_wot_network_quality_ipr_agg`.`packets_received` AS `packets_received`,
    `f_wot_network_quality_ipr_agg`.`packets_sent`     AS `packets_sent`,
    `f_wot_network_quality_ipr_agg`.`packets_resent`   AS `packets_resent`,
    `f_wot_network_quality_ipr_agg`.`date_dt`          AS `date_dt`,
    `f_wot_network_quality_ipr_agg`.`toip`             AS `toip`,
    `d_peripheries`.`periphery_id`                     AS `periphery_id`,
    `dim_countries`.`country_name`                     AS `country_name`
  FROM `dw_pr`.`f_wot_network_quality_ipr_agg` `f_wot_network_quality_ipr_agg`
  JOIN `dw_pr`.`d_peripheries` `d_peripheries`
  ON (`f_wot_network_quality_ipr_agg`.`periphery_nkey` = `d_peripheries`.`periphery_nkey`)
  JOIN `dw_pr`.`dim_countries` `dim_countries`
  ON (`f_wot_network_quality_ipr_agg`.`country_code_3_letter` = `dim_countries`.`country_code_3_letter`)
  WHERE `periphery_id`                                        =11
  AND `dt`                                                    > days_add(CURRENT_TIMESTAMP(),-1)
  ) `custom_sql_query`
WHERE false
GROUP BY 1,
  2
---



SELECT `custom_sql_query`.`city`        AS `none_city_nk`,
  `custom_sql_query`.`isp`              AS `none_isp_nk`,
  SUM(`custom_sql_query`.`batch_count`) AS `temp_tc___2391220405__0_`,
  AVG((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `avg_calculation_5120823120155293_ok`,
  COUNT((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `cnt_calculation_5120823120155293_ok`,
  SUM((
  CASE
    WHEN `custom_sql_query`.`packets_received` = 0
    THEN CAST(
      CASE
        WHEN TRUE
        THEN NULL
      END AS DOUBLE)
    ELSE CAST(`custom_sql_query`.`delay` AS DOUBLE) / `custom_sql_query`.`packets_received`
  END)) AS `sum_calculation_5120823120155293_ok`
FROM
  (SELECT `f_wot_network_quality_ipr_agg`.`dt`         AS `dt`,
    `f_wot_network_quality_ipr_agg`.`batch_count`      AS `batch_count`,
    `f_wot_network_quality_ipr_agg`.`city`             AS `city`,
    `f_wot_network_quality_ipr_agg`.`region`           AS `region`,
    `f_wot_network_quality_ipr_agg`.`delay`            AS `delay`,
    `f_wot_network_quality_ipr_agg`.`fromip`           AS `fromip`,
    `f_wot_network_quality_ipr_agg`.`isp`              AS `isp`,
    `f_wot_network_quality_ipr_agg`.`packets_received` AS `packets_received`,
    `f_wot_network_quality_ipr_agg`.`packets_sent`     AS `packets_sent`,
    `f_wot_network_quality_ipr_agg`.`packets_resent`   AS `packets_resent`,
    `f_wot_network_quality_ipr_agg`.`date_dt`          AS `date_dt`,
    `f_wot_network_quality_ipr_agg`.`toip`             AS `toip`,
    `d_peripheries`.`periphery_id`                     AS `periphery_id`,
    `dim_countries`.`country_name`                     AS `country_name`
  FROM `dw_pr`.`f_wot_network_quality_ipr_agg` `f_wot_network_quality_ipr_agg`
  JOIN `dw_pr`.`d_peripheries` `d_peripheries`
  ON (`f_wot_network_quality_ipr_agg`.`periphery_nkey` = `d_peripheries`.`periphery_nkey`)
  JOIN `dw_pr`.`dim_countries` `dim_countries`
  ON (`f_wot_network_quality_ipr_agg`.`country_code_3_letter` = `dim_countries`.`country_code_3_letter`)
  WHERE `periphery_id`                                        =11
  AND `dt`                                                    > days_add(CURRENT_TIMESTAMP(),-1)
  ) `custom_sql_query`
WHERE false
GROUP BY 1,
  2

 it happened when we upgraded from impala 1.4  to impala 2.0

Highlighted

Re: impala odbc tableau

New Contributor

These requests are sent Tableau desktop v8.2.

in impala 1.4 these queries worked

Don't have an account?
Coming from Hortonworks? Activate your account here