You can mark the table as transactional and then you can do single updates.
> On 07 Jan 2016, at 08:10, sudhir <sudhi...@gmail.com> wrote:
>
> Hi,
>
> I have a hive table of 20Lakh records and to update a row I have to load the
> entire table in dataframe and process that and then Save it (SaveAsTable in
> Overwrite mode)
>
> When I tried to update using objHiveContext.sql("Update myTable set
> columnName='test' ") , I canno so this
> I'm using spark 1.4.1 and hive 1.2.1
>
> How can I update a Hive table directly without overhead of loading it
>
> Note: It is a ORC table.
>
>
>
> --
> View this message in context:
> http://apache-spark-user-list.1001560.n3.nabble.com/Update-Hive-tables-from-Spark-without-loading-entire-table-in-to-a-dataframe-tp25902.html
> Sent from the Apache Spark User List mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
> For additional commands, e-mail: user-h...@spark.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
For additional commands, e-mail: user-h...@spark.apache.org
