#13548: Cloudera Impala- Select query for timestamp displays err as result instead time

anilkalshetti reported 2015-07-20T13:33:19Z · last modified 2015-08-03T17:21:18Z

Cloudera Impala- Select query for timestamp displays err as result instead time

Dev	SachinPrakash
QA	tomconrad

Priority	Low
Complexity	Unknown

Component	Hive
Version	17.0

Aqua Data Studio 17.0.0-dev-83
Build #: 44787
Built on: 2015-Jul-19 09:54:42 PM

OS: Ubuntu 14.04 LTE
Linux (3.13.0-55-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=4,433,379,328; Total=1,329,070,080; Free=986,494,304; CPUs=8

Database: Cloudera CDH 5.4.0 - Impala 2.2.0

Driver: Type: JDBC41- CDH5.4.0_Impala_JDBC41_v2.5.22-1040-GA
JDBC4- CDH5.4.0_Impala_JDBC4_V-2-5-22-1040-GA

Drivers downloaded from-Link

Distribution : Cloudera

Connection Type: Impala

Issue: Cloudera Impala- Select query for timestamp displays err as result

Steps to reproduce issue:
1. Copy the drivers JDBC41- in ADS- /datastudio/lib/drivers directory.
2. Launch ADSv17, Open Register Server Window, Select Apache Hive, Enter below credentials
Name: CDH540Impala220
Authentication block
Type: No Authentication

Connection Type: Impala
Host: 10.171.0.99
Port: 21050
Database: default

Save the connection. In ADS, Expand Schema Server node. Right click and open Open Query Analyzer.

3. Execute the below query
select cast('08:30:00' as timestamp)

4. It displayed result as (err)

Expected: 08:30:00
Please refer Screenshot1.png

Observation:
1. Cloudera Hue- Impala WebUI- Editor displays proper result for same query.

3 attachments

Screenshot1.png

2015-07-20T13:33:19Z

159 KB
beeline-interface-timestamp.png

2015-07-24T08:02:32Z

43 KB
impala-beeline-interface.png

2015-07-28T06:32:22Z

45 KB

All Comments (9) Change History

SachinPrakash 2015-07-23T18:21:31Z

When executed via beeline, what does beeline display?

anilkalshetti 2015-07-24T08:03:52Z

@Sachin:

beeline interface displays result properly as : 08:30:00

Please refer attached screenshot: beeline-interface-timestamp.png

SachinPrakash 2015-07-24T18:48:42Z

In your screenshot, beeline is not showing the results -- it is returning blank. Can you confirm that you're using the same hive related jars in beeline that you are using in ADS?

anilkalshetti 2015-07-28T06:32:08Z

@Sachin:

In the screenshot- beeline-interface-timestamp.png
After the select query ends with ;
next line result is displayed as: 08:30:00

and below that Column name is displayed with result as blank.

Please also check screenshot-impala-beeline-interface.png
This is Cloudera Impala bug. Observed for CDH 5.4.0 and CDH 5.4.2.0 VMWare sandbox.
For earlier versions of VM this issue is not observed. Also this issue is not observed for Hive beeline interface on CDH 5.4.0 and CDH 5.4.2.0 VMWare sandbox, It's only observed for Impala beeline interface.

anilkalshetti 2015-07-28T06:52:20Z

Other queries that shows proper result in ADS-
Timestamp unit test queries

select cast('1966-07-30' as timestamp)

select cast('1985-09-25 17:45:30.005' as timestamp)

select hour('1970-01-01 15:30:00')

-- Succeeds, returns 15.

select hour('1970-01-01 15:30')

-- Returns NULL because seconds field required.

select hour('1970-01-01 27:30:00');

-- Returns NULL because hour value out of

range.

select dayofweek('2004-06-13');

-- Returns 1, representing Sunday.

select dayname('2004-06-13');

-- Returns 'Sunday'.

select date_add('2004-06-13', 365);

-- Returns 2005-06-13 with zeros for hh:mm:ss fields.

select day('2004-06-13');

-- Returns 13.

select datediff('1989-12-31','1984-09-01'); -- How many days between these 2 dates?

select now();

-- Returns current date and time in local

timezone.

anilkalshetti 2015-07-31T04:33:57Z

@Sachin
Please check last 2 comments and screenshot:impala-beeline-interface.png

SachinPrakash 2015-08-01T05:15:55Z

@anil: I'm not sure if you have the correct screenshot attached for beeline-impala but based upon your text descriptions, the error you're receiving is a bug in impala. Nothing for us to fix.

anilkalshetti 2015-08-03T04:43:20Z

The screenshot is correct. Yes, it is impala bug.

We can close this issue

tariqrahiman 2015-08-03T17:21:18Z

Won't Fix.

Search Tips

Aqua Data Studio / nhilam

Cloudera Impala- Select query for timestamp displays err as result instead time

3 attachments

Issue #13548

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Cloudera Impala- Select query for timestamp displays err as result instead time

3 attachments

Issue #13548

Completion