How to do updation in Hive?

Hello all, I want to update a columns every time. I have table consists of 50 columns. I am applying such condition so that every time I need to update a column. I know that Hive doesn't support UPDATE and If I think about using PARTITION COLUMN so how can I maintain these columns? Is there any w

[jira] [Commented] (HIVE-2623) Add Integer type compressors

[ https://issues.apache.org/jira/browse/HIVE-2623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13206967#comment-13206967 ] Krishna Kumar commented on HIVE-2623: - I will attach cpu usage information for compress

[jira] [Commented] (HIVE-2799) change the following thrift apis to add a region

[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207033#comment-13207033 ] Kevin Wilfong commented on HIVE-2799: - Adding the following to the list to be changed.

[jira] [Commented] (HIVE-2799) change the following thrift apis to add a region

[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207134#comment-13207134 ] Ashutosh Chauhan commented on HIVE-2799: I assume all of these apis will be backwar

[jira] [Commented] (HIVE-2799) change the following thrift apis to add a region

[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207144#comment-13207144 ] Kevin Wilfong commented on HIVE-2799: - I will leave the current API's unchanged, I inte

Hive-trunk-h0.21 - Build # 1256 - Still Failing

Changes for Build #1213 Changes for Build #1214 Changes for Build #1215 Changes for Build #1216 [cws] HIVE-2724. Remove unused lib/log4j-1.2.15.jar (Andrew Bayer via cws) Changes for Build #1217 Changes for Build #1218 Changes for Build #1219 [hashutosh] HIVE-2665 : Support for metastore ser

[jira] [Commented] (HIVE-2799) change the following thrift apis to add a region

[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207193#comment-13207193 ] Carl Steinbach commented on HIVE-2799: -- I recommend adding methods that take a single

[jira] [Updated] (HIVE-2799) change the following thrift apis to add a region

[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2799: - Component/s: Thrift API Metastore > change the following thrift apis to add a

[jira] [Commented] (HIVE-2799) change the following thrift apis to add a region

[ https://issues.apache.org/jira/browse/HIVE-2799?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207206#comment-13207206 ] Kevin Wilfong commented on HIVE-2799: - Thanks, Carl, that sounds like a good idea. Unf

[jira] [Commented] (HIVE-1054) "CHANGE COLUMN" does not support changing partition column types.

[ https://issues.apache.org/jira/browse/HIVE-1054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207238#comment-13207238 ] Kevin Wilfong commented on HIVE-1054: - Yongqiang, could you comment on why this should

[jira] [Updated] (HIVE-2795) View partitions do not have a storage descriptor

[ https://issues.apache.org/jira/browse/HIVE-2795?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2795: - Component/s: Metastore Fix Version/s: 0.9.0 > View partitions do not have a storage desc

[jira] [Created] (HIVE-2804) Task log retrieval fails on secure cluster

Task log retrieval fails on secure cluster -- Key: HIVE-2804 URL: https://issues.apache.org/jira/browse/HIVE-2804 Project: Hive Issue Type: Bug Components: Diagnosability, Query Processor

[jira] [Updated] (HIVE-2804) Task log retrieval fails on secure cluster

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2804: - Component/s: Security > Task log retrieval fails on secure cluster > -

[jira] [Commented] (HIVE-2804) Task log retrieval fails on secure cluster

[ https://issues.apache.org/jira/browse/HIVE-2804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207354#comment-13207354 ] Carl Steinbach commented on HIVE-2804: -- On a secure Hadoop cluster TaskLogProcessor.ge

[jira] [Resolved] (HIVE-2618) Describe partition returns table columns but should return partition columns

[ https://issues.apache.org/jira/browse/HIVE-2618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach resolved HIVE-2618. -- Resolution: Duplicate Looks like this patch was included in the fix for HIVE-1003. Resolving as

[jira] [Reopened] (HIVE-2618) Describe partition returns table columns but should return partition columns

[ https://issues.apache.org/jira/browse/HIVE-2618?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach reopened HIVE-2618: -- > Describe partition returns table columns but should return partition columns > ---

[jira] [Updated] (HIVE-2795) View partitions do not have a storage descriptor

[ https://issues.apache.org/jira/browse/HIVE-2795?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2795: - Release Note: Requires upgrade of the metadata corresponding to partitioned views. Please see the

[jira] [Updated] (HIVE-2612) support hive table/partitions exists in more than one region

[ https://issues.apache.org/jira/browse/HIVE-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2612: - Release Note: Requires a metastore upgrade. > support hive table/partitions exists in more tha

Re: How to do updation in Hive?

Hi Bhavesh, I am no expert in this matter but typical Hive use cases don't involve updates. If your workflow, relies considerably on updating existing data in Hive (i.e. in HDFS), you might need to re-think your design or the tools you use. Mark Mark Grover, Business Intelligence Analyst OANDA

[jira] [Commented] (HIVE-1444) "hdfs" is hardcoded in few places in the code which inhibits use of other file systems

[ https://issues.apache.org/jira/browse/HIVE-1444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207408#comment-13207408 ] T Jake Luciani commented on HIVE-1444: -- bump > "hdfs" is hardcoded in

[jira] [Commented] (HIVE-2753) Remove empty java files

[ https://issues.apache.org/jira/browse/HIVE-2753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207426#comment-13207426 ] Ashutosh Chauhan commented on HIVE-2753: @Carl, Would you like to give this a try

[jira] [Commented] (HIVE-2753) Remove empty java files

[ https://issues.apache.org/jira/browse/HIVE-2753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207456#comment-13207456 ] Phabricator commented on HIVE-2753: --- cwsteinbach has accepted the revision "HIVE-2753 [ji

[jira] [Updated] (HIVE-2753) Remove empty java files

[ https://issues.apache.org/jira/browse/HIVE-2753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2753: - Resolution: Fixed Fix Version/s: 0.9.0 Hadoop Flags: Reviewed Status: Resolv

[jira] [Commented] (HIVE-2782) New BINARY type produces unexpected results with supported UDFS when using MapReduce2

[ https://issues.apache.org/jira/browse/HIVE-2782?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207475#comment-13207475 ] Carl Steinbach commented on HIVE-2782: -- @Ashutosh: Do you have time to take a look at

[jira] [Updated] (HIVE-2793) Disable loadpart_err.q on 0.23

[ https://issues.apache.org/jira/browse/HIVE-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Carl Steinbach updated HIVE-2793: - Status: Patch Available (was: Open) > Disable loadpart_err.q on 0.23 > --

[jira] [Commented] (HIVE-2381) SQLException thrown when the resultset becomes empty.

[ https://issues.apache.org/jira/browse/HIVE-2381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207552#comment-13207552 ] Masato Setoyama commented on HIVE-2381: --- Excuse me for my poor English.. I experienc

[jira] [Commented] (HIVE-2753) Remove empty java files

[ https://issues.apache.org/jira/browse/HIVE-2753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13207557#comment-13207557 ] Hudson commented on HIVE-2753: -- Integrated in Hive-trunk-h0.21 #1257 (See [https://builds.apa

Hive-trunk-h0.21 - Build # 1257 - Still Failing

Changes for Build #1216 [cws] HIVE-2724. Remove unused lib/log4j-1.2.15.jar (Andrew Bayer via cws) Changes for Build #1217 Changes for Build #1218 Changes for Build #1219 [hashutosh] HIVE-2665 : Support for metastore service specific HADOOP_OPTS environment setting (thw via hashutosh) Change