Re: Special characters in web log file causing issues

yes Raj, thats a unix command On Tue, Jul 9, 2013 at 6:48 AM, Hadoop Raj wrote: > Hi Sanjay, > > Is that a unix trap command or any other thing? Please let me know. > > > Sent from my iPhone > > On Jul 8, 2013, at 7:46 PM, Sanjay Subramanian < > sanjay.subraman...@wizecommerce.com> wrote: > >

Re: Hive CLI

Hi Rahul, The same shortcuts ctrl+A and ctrl+E works in hive shell for me( hive 0.9) Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- From: rahul kavale Date: Tue, 9 Jul 2013 11:00:49 To: Reply-To: user@hive.apache.org Subject: Hive CLI Hey there, I

Re: Hive CLI

Sorry My bad, it was my bad as Ctrl-a was screen binding which is why I was not able to use it for moving cursor. This had nothing to do with Hive or its configuration. My bad Thanks & Regards, Rahul On 9 July 2013 11:00, rahul kavale wrote: > Hey there, > I have been using HIVE(0.7) for a whi

Hive CLI

Hey there, I have been using HIVE(0.7) for a while now using CLI and bash scripts. But its a pain to move cursor in the CLI i.e. once you enter a very long query then you cant go to start of the query (like you do using Ctrl+A/Ctrl+E in terminal). Does anyone know how to do it? Thanks & Regards, R

start HWI error

i am testing hive web interface, anyone can help? thanks content in hive-site.xml hive.hwi.war.file /usr/lib/hive/lib/hive-hwi-0.7.1-cdh3u4.war This is the WAR file with the jsp content for Hive Web Interface # export ANT_LIB=/usr/share/ant/lib # hive --service hwi 13/07/09 13:19:40 INFO

Re: Special characters in web log file causing issues

Hi Sanjay, Is that a unix trap command or any other thing? Please let me know. Sent from my iPhone On Jul 8, 2013, at 7:46 PM, Sanjay Subramanian wrote: > U may have to remove non-printable chars first, save an intermediate file and > then load into Hive > > tr -cd '[:print:]\r\n\t' > > O

Re: Special characters in web log file causing issues

U may have to remove non-printable chars first, save an intermediate file and then load into Hive tr -cd '[:print:]\r\n\t' Or if u have strings function that will only output printable chars From: Raj Hadoop mailto:hadoop...@yahoo.com>> Reply-To: "user@hive.apache.org

Special characters in web log file causing issues

Hi ,   The log file that I am trying to load throuh Hive has some special characters    The field is shown below and the special characters ¿¿are also shown.  Shockwave Flash in;Motive ManagementPlug-in;Google Update;Java(TM)Platform SE 7U21;McAfee SiteAdvisor;McAfee Virtual Technician;W

Re: Need help in Hive

Hi Maheedhar As I understand, you are having a column with data of type MM:SS in your input data set. AFAIK this format is not in the standard java.sql.Timestamp format also it doesn't even have any date part . Hence you may not be able to use Timestamp data type here. You can define it as a

Re: integration issure about hive and hbase

Hi Can you try including the zookeeper quorum and port in your hive configuration as shown below hive --auxpath .../hbase-handler.jar, .../hbase.jar, ...zookeeper.jar, .../guava.jar -hiveconf hbase.zookeeper.quorum= -hiveconf hbase.zookeeper.property.clientPort= Substitute the above command wi

Re: Strange error in hive

Hii Jerome Can you send the error log of the MapReduce task that failed? That should have some pointers which can help you troubleshoot the issue. Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- From: Jérôme Verdier Date: Mon, 8 Jul 2013 11:25:34 To

Strange error in hive

Hi everybody, I faced a strange error in hive this morning. The error message is this one : FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask after a quick search on Google, it appears that this is a Hive bug : https://issues.apache.org/jira/browse/HIVE-4650

Re: integration issure about hive and hbase

i replace the zookeeper jar ,the error is different hive> CREATE TABLE hbase_table_1(key int, value string) > STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' > WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val") > TBLPROPERTIES ("hbase.table.name" = "xyz"); FAI

Re: integration issure about hive and hbase

and i have zookeeper on port 2281 ,not default port On Mon, Jul 8, 2013 at 2:52 PM, Cheng Su wrote: > Did you hbase cluster start up? > > The error message is more like that something wrong with the classpath. > So maybe you'd better also check that. > > > On Mon, Jul 8, 2013 at 1:54 PM, ch hu

Re: integration issure about hive and hbase

hbase cluster is running and i also define the jar path in hive-site.xml hive.aux.jars.path file:///usr/lib/hive/lib/hive-hbase-handler-0.7.1-cdh3u4.jar,file:///usr/lib/hive/lib/hbase-0.90.6-cdh3u4.jar,file:///usr/lib/hive/lib/zookeeper-3.3.1.jar On Mon, Jul 8, 2013 at 2:52 PM, Cheng Su wro

Re: Need help in Hive

Hello, Try this function in hive query: 1- transform your data (type integer ) in timestamp (linux), then do this: 2- from_unixtimeyour_date_timestamp), 'mm:ss') AS time Hope this, you will give help. 2013/7/8 Maheedhar Reddy > Hi All, > > I have Hive 0.8.0 version installed in my single nod