You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Shawn Weeks (JIRA)" <ji...@apache.org> on 2017/01/22 20:07:26 UTC
[jira] [Created] (HIVE-15692) Can't Create Table with Interval
Column Type
Shawn Weeks created HIVE-15692:
----------------------------------
Summary: Can't Create Table with Interval Column Type
Key: HIVE-15692
URL: https://issues.apache.org/jira/browse/HIVE-15692
Project: Hive
Issue Type: Bug
Components: Parser
Affects Versions: 1.2.1
Environment: CentOS 6.8 Hortonworks HDP 2.5 Apache Hive (version 1.2.1000.2.5.3.0-37)
Reporter: Shawn Weeks
Priority: Minor
You can create a table with an interval type via create table as select but not directly with create table.
This Works
{{create table test_interval
as
select interval '1' day as day_interval,
interval '1' month as month_interval;}}
This raises an error.
{{create table test_interval(
day_interval interval_day_time,
month_interval interval_year_month
);}}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)