Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Date Format

Hello!

I have connected my dashboard to Hive with QvOdbcConnectorPackage and I have selected Apache Hive.

After that I have the script, and I want to convert one of the fields to a date fields

For example:

     SELECT

     fechamodificacion AS [Fecha modificación],

    day(fechamodificacion) as fecha_dia,

    Year(fechamodificacion) as fecha_año,

    Month(fechamodificacion) as fecha_mes,

    WeekDay(fechamodificacion) as fecha_semana_mes,

       Week (fechamodificacion)as fecha_semana_mes_2,

     FROM .....

This produce an error:

Unable to get column information for the fields that are used in the query:

    ERROR [HY000] [Qlik][ODBC Apache Hive Wire Protocol driver][Apache Hive]Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

Does anyone know how can I do that?

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

you could try a presceding Load:

Load

fechamodificacion AS [Fecha modificación],

    day(fechamodificacion) as fecha_dia,

    Year(fechamodificacion) as fecha_año,

    Month(fechamodificacion) as fecha_mes,

    WeekDay(fechamodificacion) as fecha_semana_mes,

   Week (fechamodificacion)as fecha_semana_mes_2

;

SELECT *

FROM....

View solution in original post

2 Replies
Highlighted
Specialist II
Specialist II

you could try a presceding Load:

Load

fechamodificacion AS [Fecha modificación],

    day(fechamodificacion) as fecha_dia,

    Year(fechamodificacion) as fecha_año,

    Month(fechamodificacion) as fecha_mes,

    WeekDay(fechamodificacion) as fecha_semana_mes,

   Week (fechamodificacion)as fecha_semana_mes_2

;

SELECT *

FROM....

View solution in original post

Highlighted
Contributor III
Contributor III

Thank you so much!

That works perfectly!