[jira] [Commented] (HIVE-25451) from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01
[
https://issues.apache.org/jira/browse/HIVE-25451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17403489#comment-17403489
]
Anurag Shekhar commented on HIVE-25451:
---
As per timezone data from IANA this is correct conversion.
> from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01
> ---
>
> Key: HIVE-25451
> URL: https://issues.apache.org/jira/browse/HIVE-25451
> Project: Hive
> Issue Type: Bug
> Components: UDF
>Reporter: Anurag Shekhar
>Priority: Minor
>
> from beeline
> select from_utc_timestamp('1895-12-01', 'Australia/Perth');
> ++
> | _c0 |
> ++
> | 1895-12-01 08:00:00.0 |
> ++
> This one is using correct offset of 8 hours.
> Same query with date as 1895-11-30
> select from_utc_timestamp('1895-11-30', 'Australia/Perth');
> ++
> | _c0 |
> ++
> | 1895-11-30 07:43:24.0 |
> ++
> Now the offset is 07:43:24.0
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Resolved] (HIVE-25451) from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01
[
https://issues.apache.org/jira/browse/HIVE-25451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anurag Shekhar resolved HIVE-25451.
---
Resolution: Invalid
> from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01
> ---
>
> Key: HIVE-25451
> URL: https://issues.apache.org/jira/browse/HIVE-25451
> Project: Hive
> Issue Type: Bug
> Components: UDF
>Reporter: Anurag Shekhar
>Priority: Minor
>
> from beeline
> select from_utc_timestamp('1895-12-01', 'Australia/Perth');
> ++
> | _c0 |
> ++
> | 1895-12-01 08:00:00.0 |
> ++
> This one is using correct offset of 8 hours.
> Same query with date as 1895-11-30
> select from_utc_timestamp('1895-11-30', 'Australia/Perth');
> ++
> | _c0 |
> ++
> | 1895-11-30 07:43:24.0 |
> ++
> Now the offset is 07:43:24.0
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Updated] (HIVE-25451) from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01
[
https://issues.apache.org/jira/browse/HIVE-25451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anurag Shekhar updated HIVE-25451:
--
Description:
from beeline
select from_utc_timestamp('1895-12-01', 'Australia/Perth');
++
| _c0 |
++
| 1895-12-01 08:00:00.0 |
++
This one is using correct offset of 8 hours.
Same query with date as 1895-11-30
select from_utc_timestamp('1895-11-30', 'Australia/Perth');
++
| _c0 |
++
| 1895-11-30 07:43:24.0 |
++
Now the offset is 07:43:24.0
> from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01
> ---
>
> Key: HIVE-25451
> URL: https://issues.apache.org/jira/browse/HIVE-25451
> Project: Hive
> Issue Type: Bug
> Components: UDF
>Reporter: Anurag Shekhar
>Priority: Minor
>
> from beeline
> select from_utc_timestamp('1895-12-01', 'Australia/Perth');
> ++
> | _c0 |
> ++
> | 1895-12-01 08:00:00.0 |
> ++
> This one is using correct offset of 8 hours.
> Same query with date as 1895-11-30
> select from_utc_timestamp('1895-11-30', 'Australia/Perth');
> ++
> | _c0 |
> ++
> | 1895-11-30 07:43:24.0 |
> ++
> Now the offset is 07:43:24.0
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Updated] (HIVE-25451) from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01
[
https://issues.apache.org/jira/browse/HIVE-25451?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anurag Shekhar updated HIVE-25451:
--
Environment: (was: from beeline
select from_utc_timestamp('1895-12-01', 'Australia/Perth');
++
| _c0 |
++
| 1895-12-01 08:00:00.0 |
++
This one is using correct offset of 8 hours.
Same query with date as 1895-11-30
select from_utc_timestamp('1895-11-30', 'Australia/Perth');
++
| _c0 |
++
| 1895-11-30 07:43:24.0 |
++
Now the offset is 07:43:24.0)
> from_utc_timestamp uses wrong timezone offset for dates prior to 1895-12-01
> ---
>
> Key: HIVE-25451
> URL: https://issues.apache.org/jira/browse/HIVE-25451
> Project: Hive
> Issue Type: Bug
> Components: UDF
>Reporter: Anurag Shekhar
>Priority: Minor
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Resolved] (HIVE-25470) Hive returns wrong value for select query involving time conversion
[
https://issues.apache.org/jira/browse/HIVE-25470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anurag Shekhar resolved HIVE-25470.
---
Resolution: Duplicate
> Hive returns wrong value for select query involving time conversion
> ---
>
> Key: HIVE-25470
> URL: https://issues.apache.org/jira/browse/HIVE-25470
> Project: Hive
> Issue Type: Bug
> Components: UDF
>Reporter: Anurag Shekhar
>Assignee: Anurag Shekhar
>Priority: Minor
>
> Select
> to_date(CAST(FROM_UNIXTIME(UNIX_TIMESTAMP(date_add('0021-02-01',cast(20 as
> int)),'-MM-dd')) as timestamp));
> -
> _c0
> -
> 0021-02-23
> -
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Assigned] (HIVE-25470) Hive returns wrong value for select query involving time conversion
[
https://issues.apache.org/jira/browse/HIVE-25470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anurag Shekhar reassigned HIVE-25470:
-
> Hive returns wrong value for select query involving time conversion
> ---
>
> Key: HIVE-25470
> URL: https://issues.apache.org/jira/browse/HIVE-25470
> Project: Hive
> Issue Type: Bug
> Components: UDF
>Reporter: Anurag Shekhar
>Assignee: Anurag Shekhar
>Priority: Minor
>
> Select
> to_date(CAST(FROM_UNIXTIME(UNIX_TIMESTAMP(date_add('0021-02-01',cast(20 as
> int)),'-MM-dd')) as timestamp));
> -
> _c0
> -
> 0021-02-23
> -
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Assigned] (HIVE-25056) cast ('000-00-00 00:00:00' as timestamp/datetime) results in wrong conversion
[
https://issues.apache.org/jira/browse/HIVE-25056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anurag Shekhar reassigned HIVE-25056:
-
> cast ('000-00-00 00:00:00' as timestamp/datetime) results in wrong conversion
> --
>
> Key: HIVE-25056
> URL: https://issues.apache.org/jira/browse/HIVE-25056
> Project: Hive
> Issue Type: Bug
>Reporter: Anurag Shekhar
>Assignee: Anurag Shekhar
>Priority: Minor
>
> select cast ('-00-00' as date) , cast ('000-00-00 00:00:00' as timestamp)
> +--+---+
> |_c0|_c1|
> +--+---+
> |0002-11-30|0002-11-30 00:00:00.0|
> +--+---+
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Updated] (HIVE-24891) Tablestamp field returns a value different from what was inserted using PreparedStaement.setLong
[
https://issues.apache.org/jira/browse/HIVE-24891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anurag Shekhar updated HIVE-24891:
--
Summary: Tablestamp field returns a value different from what was inserted
using PreparedStaement.setLong (was: Tablestamp field returns a value
different from what was inserted using PreparedStaement.setLog)
> Tablestamp field returns a value different from what was inserted using
> PreparedStaement.setLong
>
>
> Key: HIVE-24891
> URL: https://issues.apache.org/jira/browse/HIVE-24891
> Project: Hive
> Issue Type: Bug
> Components: JDBC
>Reporter: Anurag Shekhar
>Priority: Minor
>
> Setup
> Hive Cluster Timezone - UTC
> JDBC Client Timezone - IST
> Create timestamp "ts = Timestamp.valueOf("2021-03-16 00:00:00.000");"
> Insert using PreparedStatement (call setLong (index, ts.getTime())
> Query Same field.
> Return Timestamp differs from the one inserted.
> Reproduction Code
> {code:java}
> private static String getFormattedTimestamp(Timestamp ts) {
> SimpleDateFormat format = new SimpleDateFormat("-MM-dd'T'HH:mm:ss.SSS
> z");
> return format.format(ts);
> }
> public static void main (String [] arg) throws SQLException {
> TimeZone.setDefault(TimeZone.getTimeZone("IST"));
> Connection conn = DriverManager.getConnection
> ("jdbc:hive2://anurag-hwc-2.anurag-hwc.root.hwx.site:1", "hive", "hive");
> Statement stmt = conn.createStatement();
> stmt.execute("drop table if exists ts_table");
> stmt.execute("create table ts_table (ts timestamp) stored as orc");
> PreparedStatement pStmt = conn.prepareStatement("insert into ts_table
> (ts) values (?)");
> long timeStamp = System.currentTimeMillis();
> Timestamp ts = Timestamp.valueOf("2021-03-16 00:00:00.000");
> pStmt.setLong (1, ts.getTime());
> pStmt.execute();
> pStmt.close();
> System.out.println ("Inserted " + getFormattedTimestamp(ts) + " In millis
> " + ts.getTime());
> ResultSet rs = stmt.executeQuery("Select * from ts_table");
> rs.next();
> Timestamp resultTs = rs.getTimestamp(1);
> System.out.println("Retrieved " + getFormattedTimestamp(resultTs) + " In
> millis " + resultTs.getTime());
> rs.close();
> } {code}
>
> Output of above code
> Inserted 2021-03-16T00:00:00.000 IST In millis 161583300
> Retrieved 2021-03-15T18:30:00.000 IST In millis 161581320
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Commented] (HIVE-24888) JDBC Query with where clause containing timestamp field in long doesn't return any result.
[
https://issues.apache.org/jira/browse/HIVE-24888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17303158#comment-17303158
]
Anurag Shekhar commented on HIVE-24888:
---
This issue could be a side effect of HIVE-24891
> JDBC Query with where clause containing timestamp field in long doesn't
> return any result.
> --
>
> Key: HIVE-24888
> URL: https://issues.apache.org/jira/browse/HIVE-24888
> Project: Hive
> Issue Type: Bug
> Components: JDBC
>Reporter: Anurag Shekhar
>Priority: Minor
>
> Steps to reproduce
> The following code creates a table with timestamp column and inserts a value,
> using java.sql.PreparedStament.setLong.
> When same value used to query the table it returns no results.
> Other variant, using timestamp (setTimestamp) string (setString) works fine.
> {code:java}
> public static void main(String [] args) throws SQLException {
> TimeZone.setDefault(TimeZone.getTimeZone("IST"));
> Connection conn = DriverManager.getConnection ("jdbc:hive2://host:port",
> "hive", "hive");
> Statement stmt = conn.createStatement();
> stmt.execute("drop table if exists ts_table");
> stmt.execute("create table ts_table (ts timestamp) stored as orc");
> PreparedStatement pStmt = conn.prepareStatement("insert into ts_table
> (ts) values (?)");
> long timeStamp = System.currentTimeMillis();
> pStmt.setLong(1, timeStamp);
> pStmt.execute();
> pStmt.close();
> pStmt = conn.prepareStatement("select * from ts_table where ts = ?");
> pStmt.setLong(1, timeStamp);
> ResultSet rs = pStmt.executeQuery();
> if (rs.next()) {
> Timestamp resultTs = rs.getTimestamp(1);
> System.out.println("Retrieved " + resultTs + " In millis " +
> resultTs.getTime());
> System.out.println("where ts = " + timeStamp);
> }
> else
> System.out.println ("No result where ts = " + timeStamp);
> rs.close();
> pStmt.close();
> conn.close();
> }{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Updated] (HIVE-24891) Tablestamp field returns a value different from what was inserted using PreparedStaement.setLog
[
https://issues.apache.org/jira/browse/HIVE-24891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anurag Shekhar updated HIVE-24891:
--
Description:
Setup
Hive Cluster Timezone - UTC
JDBC Client Timezone - IST
Create timestamp "ts = Timestamp.valueOf("2021-03-16 00:00:00.000");"
Insert using PreparedStatement (call setLong (index, ts.getTime())
Query Same field.
Return Timestamp differs from the one inserted.
Reproduction Code
{code:java}
private static String getFormattedTimestamp(Timestamp ts) {
SimpleDateFormat format = new SimpleDateFormat("-MM-dd'T'HH:mm:ss.SSS
z");
return format.format(ts);
}
public static void main (String [] arg) throws SQLException {
TimeZone.setDefault(TimeZone.getTimeZone("IST"));
Connection conn = DriverManager.getConnection
("jdbc:hive2://anurag-hwc-2.anurag-hwc.root.hwx.site:1", "hive", "hive");
Statement stmt = conn.createStatement();
stmt.execute("drop table if exists ts_table");
stmt.execute("create table ts_table (ts timestamp) stored as orc");
PreparedStatement pStmt = conn.prepareStatement("insert into ts_table (ts)
values (?)");
long timeStamp = System.currentTimeMillis();
Timestamp ts = Timestamp.valueOf("2021-03-16 00:00:00.000");
pStmt.setLong (1, ts.getTime());
pStmt.execute();
pStmt.close();
System.out.println ("Inserted " + getFormattedTimestamp(ts) + " In millis "
+ ts.getTime());
ResultSet rs = stmt.executeQuery("Select * from ts_table");
rs.next();
Timestamp resultTs = rs.getTimestamp(1);
System.out.println("Retrieved " + getFormattedTimestamp(resultTs) + " In
millis " + resultTs.getTime());
rs.close();
} {code}
Output of above code
Inserted 2021-03-16T00:00:00.000 IST In millis 161583300
Retrieved 2021-03-15T18:30:00.000 IST In millis 161581320
Environment: (was: Setup
Hive Cluster Timezone - UTC
JDBC Client Timezone - IST
Create timestamp "ts = Timestamp.valueOf("2021-03-16 00:00:00.000");"
Insert using PreparedStatement (call setLong (index, ts.getTime())
Query Same field.
Return Timestamp differs from the one inserted.
Reproduction Code
{code:java}
private static String getFormattedTimestamp(Timestamp ts) {
SimpleDateFormat format = new SimpleDateFormat("-MM-dd'T'HH:mm:ss.SSS
z");
return format.format(ts);
}
public static void main (String [] arg) throws SQLException {
TimeZone.setDefault(TimeZone.getTimeZone("IST"));
Connection conn = DriverManager.getConnection
("jdbc:hive2://anurag-hwc-2.anurag-hwc.root.hwx.site:1", "hive", "hive");
Statement stmt = conn.createStatement();
stmt.execute("drop table if exists ts_table");
stmt.execute("create table ts_table (ts timestamp) stored as orc");
PreparedStatement pStmt = conn.prepareStatement("insert into ts_table (ts)
values (?)");
long timeStamp = System.currentTimeMillis();
Timestamp ts = Timestamp.valueOf("2021-03-16 00:00:00.000");
pStmt.setLong (1, ts.getTime());
pStmt.execute();
pStmt.close();
System.out.println ("Inserted " + getFormattedTimestamp(ts) + " In millis "
+ ts.getTime());
ResultSet rs = stmt.executeQuery("Select * from ts_table");
rs.next();
Timestamp resultTs = rs.getTimestamp(1);
System.out.println("Retrieved " + getFormattedTimestamp(resultTs) + " In
millis " + resultTs.getTime());
rs.close();
} {code}
Output of above code
Inserted 2021-03-16T00:00:00.000 IST In millis 161583300
Retrieved 2021-03-15T18:30:00.000 IST In millis 161581320)
> Tablestamp field returns a value different from what was inserted using
> PreparedStaement.setLog
> ---
>
> Key: HIVE-24891
> URL: https://issues.apache.org/jira/browse/HIVE-24891
> Project: Hive
> Issue Type: Bug
> Components: JDBC
>Reporter: Anurag Shekhar
>Priority: Minor
>
> Setup
> Hive Cluster Timezone - UTC
> JDBC Client Timezone - IST
> Create timestamp "ts = Timestamp.valueOf("2021-03-16 00:00:00.000");"
> Insert using PreparedStatement (call setLong (index, ts.getTime())
> Query Same field.
> Return Timestamp differs from the one inserted.
> Reproduction Code
> {code:java}
> private static String getFormattedTimestamp(Timestamp ts) {
> SimpleDateFormat format = new SimpleDateFormat("-MM-dd'T'HH:mm:ss.SSS
> z");
> return format.format(ts);
> }
> public static void main (String [] arg) throws SQLException {
> TimeZone.setDefault(TimeZone.getTimeZone("IST"));
> Connection conn = DriverManager.getConnection
> ("jdbc:hive2://anurag-hwc-2.anurag-hwc.root.hwx.site:1", "hive", "hive");
> Statement stmt = conn.createStatement();
> stmt.execute("drop table if exists ts_table");
> stmt.execute("create table ts_table (ts timestamp) stored as
[jira] [Comment Edited] (HIVE-24888) JDBC Query with where clause containing timestamp field in long doesn't return any result.
[
https://issues.apache.org/jira/browse/HIVE-24888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17302333#comment-17302333
]
Anurag Shekhar edited comment on HIVE-24888 at 3/16/21, 8:48 AM:
-
There is no exception thrown back to client application.
On beeline
> set hive.strict.timestamp.conversion;
++
| set |
++
| hive.strict.timestamp.conversion is undefined |
++
was (Author: anuragshekhar):
There is no exception thrown back to client application.
> JDBC Query with where clause containing timestamp field in long doesn't
> return any result.
> --
>
> Key: HIVE-24888
> URL: https://issues.apache.org/jira/browse/HIVE-24888
> Project: Hive
> Issue Type: Bug
> Components: JDBC
>Reporter: Anurag Shekhar
>Priority: Minor
>
> Steps to reproduce
> The following code creates a table with timestamp column and inserts a value,
> using java.sql.PreparedStament.setLong.
> When same value used to query the table it returns no results.
> Other variant, using timestamp (setTimestamp) string (setString) works fine.
> {code:java}
> public static void main(String [] args) throws SQLException {
> TimeZone.setDefault(TimeZone.getTimeZone("IST"));
> Connection conn = DriverManager.getConnection ("jdbc:hive2://host:port",
> "hive", "hive");
> Statement stmt = conn.createStatement();
> stmt.execute("drop table if exists ts_table");
> stmt.execute("create table ts_table (ts timestamp) stored as orc");
> PreparedStatement pStmt = conn.prepareStatement("insert into ts_table
> (ts) values (?)");
> long timeStamp = System.currentTimeMillis();
> pStmt.setLong(1, timeStamp);
> pStmt.execute();
> pStmt.close();
> pStmt = conn.prepareStatement("select * from ts_table where ts = ?");
> pStmt.setLong(1, timeStamp);
> ResultSet rs = pStmt.executeQuery();
> if (rs.next()) {
> Timestamp resultTs = rs.getTimestamp(1);
> System.out.println("Retrieved " + resultTs + " In millis " +
> resultTs.getTime());
> System.out.println("where ts = " + timeStamp);
> }
> else
> System.out.println ("No result where ts = " + timeStamp);
> rs.close();
> pStmt.close();
> conn.close();
> }{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Commented] (HIVE-24888) JDBC Query with where clause containing timestamp field in long doesn't return any result.
[
https://issues.apache.org/jira/browse/HIVE-24888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17302333#comment-17302333
]
Anurag Shekhar commented on HIVE-24888:
---
There is no exception thrown back to client application.
> JDBC Query with where clause containing timestamp field in long doesn't
> return any result.
> --
>
> Key: HIVE-24888
> URL: https://issues.apache.org/jira/browse/HIVE-24888
> Project: Hive
> Issue Type: Bug
> Components: JDBC
>Reporter: Anurag Shekhar
>Priority: Minor
>
> Steps to reproduce
> The following code creates a table with timestamp column and inserts a value,
> using java.sql.PreparedStament.setLong.
> When same value used to query the table it returns no results.
> Other variant, using timestamp (setTimestamp) string (setString) works fine.
> {code:java}
> public static void main(String [] args) throws SQLException {
> TimeZone.setDefault(TimeZone.getTimeZone("IST"));
> Connection conn = DriverManager.getConnection ("jdbc:hive2://host:port",
> "hive", "hive");
> Statement stmt = conn.createStatement();
> stmt.execute("drop table if exists ts_table");
> stmt.execute("create table ts_table (ts timestamp) stored as orc");
> PreparedStatement pStmt = conn.prepareStatement("insert into ts_table
> (ts) values (?)");
> long timeStamp = System.currentTimeMillis();
> pStmt.setLong(1, timeStamp);
> pStmt.execute();
> pStmt.close();
> pStmt = conn.prepareStatement("select * from ts_table where ts = ?");
> pStmt.setLong(1, timeStamp);
> ResultSet rs = pStmt.executeQuery();
> if (rs.next()) {
> Timestamp resultTs = rs.getTimestamp(1);
> System.out.println("Retrieved " + resultTs + " In millis " +
> resultTs.getTime());
> System.out.println("where ts = " + timeStamp);
> }
> else
> System.out.println ("No result where ts = " + timeStamp);
> rs.close();
> pStmt.close();
> conn.close();
> }{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
[jira] [Updated] (HIVE-24818) REPL LOAD of views with partitions fails
[ https://issues.apache.org/jira/browse/HIVE-24818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar updated HIVE-24818: -- Summary: REPL LOAD of views with partitions fails (was: REPL LOAD (Bootstrap ) of views with partitions fails ) > REPL LOAD of views with partitions fails > - > > Key: HIVE-24818 > URL: https://issues.apache.org/jira/browse/HIVE-24818 > Project: Hive > Issue Type: Bug > Components: repl >Reporter: Anurag Shekhar >Assignee: Anurag Shekhar >Priority: Major > Labels: pull-request-available > Time Spent: 40m > Remaining Estimate: 0h > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Assigned] (HIVE-24842) SHOW CREATE TABLE on a VIEW with partition returns wrong sql.
[ https://issues.apache.org/jira/browse/HIVE-24842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar reassigned HIVE-24842: - > SHOW CREATE TABLE on a VIEW with partition returns wrong sql. > -- > > Key: HIVE-24842 > URL: https://issues.apache.org/jira/browse/HIVE-24842 > Project: Hive > Issue Type: Bug > Components: HiveServer2 >Reporter: Anurag Shekhar >Assignee: Anurag Shekhar >Priority: Minor > > Steps to reproduce > Create a view with partitions. > execute "Show create table " on above view. > The sql returned will not have partitioned on clause in it. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-24818) REPL LOAD (Bootstrap ) of views with partitions fails
[ https://issues.apache.org/jira/browse/HIVE-24818?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17294505#comment-17294505 ] Anurag Shekhar commented on HIVE-24818: --- Steps to reproduce # Create an external table with one partition # create a view with partition on above table (using sql CREATE VIEW PARTITIONED ON (colName) as Select from # Take a bootstrap dump of the database # Try to load in another database Load will fail with partition column name conflict with table columns, while loading view. > REPL LOAD (Bootstrap ) of views with partitions fails > -- > > Key: HIVE-24818 > URL: https://issues.apache.org/jira/browse/HIVE-24818 > Project: Hive > Issue Type: Bug > Components: repl >Reporter: Anurag Shekhar >Assignee: Anurag Shekhar >Priority: Major > Labels: pull-request-available > Time Spent: 20m > Remaining Estimate: 0h > -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Assigned] (HIVE-24818) REPL LOAD (Bootstrap ) of views with partitions fails
[ https://issues.apache.org/jira/browse/HIVE-24818?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar reassigned HIVE-24818: - > REPL LOAD (Bootstrap ) of views with partitions fails > -- > > Key: HIVE-24818 > URL: https://issues.apache.org/jira/browse/HIVE-24818 > Project: Hive > Issue Type: Bug > Components: repl >Reporter: Anurag Shekhar >Assignee: Anurag Shekhar >Priority: Major > -- This message was sent by Atlassian Jira (v8.3.4#803005)
