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