search

google-code-export / google-bigquery

Automatically exported from code.google.com/p/google-bigquery
1 stars 0 forks source link

I have encountered a bug in the BigQuery CLI. #223

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
 Im not sure, sorry...

What is the expected output? What do you see instead?
 The message as below would not be appeared any more.
============================================================================
Job winged-octagon-840:bqjob_r3bf4d9d895a285ef_0000014bb0f5e0b8_1

  Job Type    State      Start Time      Duration   Bytes Processed
 ---------- --------- ----------------- ---------- -----------------
  query      FAILURE   22 Feb 20:04:39   0:00:00

You have encountered a bug in the BigQuery CLI. Please file a bug report in our 
public issue tracker:
https://code.google.com/p/google-bigquery/issues/list
Please include a brief description of the steps that led to this issue, as well 
as the following information:

========================================
== Platform ==
  CPython:2.6.6:Linux-2.6.32-431.29.2.el6.x86_64-x86_64-with-centos-6.6-Final
== bq version ==
  2.0.22
== Command line ==
  ['/usr/local/google-cloud-sdk/platform/bq/bq.py', '--credential_file', '/root/.config/gcloud/legacy_credentials/hoshina@gmail.com/singlestore.json', '--project', 'winged-octagon-840', 'show', '-j', 'bqjob_r3bf4d9d895a285ef_0000014bb0f5e0b8_1']
== UTC timestamp ==
  2015-02-22 11:08:49
== Error trace ==
  File "/usr/local/google-cloud-sdk/platform/bq/bq.py", line 719, in RunSafely
    return_value = self.RunWithArgs(*args, **kwds)
  File "/usr/local/google-cloud-sdk/platform/bq/bq.py", line 1684, in RunWithArgs
    _PrintObjectInfo(object_info, reference, custom_format=custom_format)
  File "/usr/local/google-cloud-sdk/platform/bq/bq.py", line 1707, in _PrintObjectInfo
    print 'Errors encountered during job execution. %s\n' % (error,)
========================================

Unexpected exception in show operation: 'ascii' codec can't encode characters 
in position 37-40: ordinal not in range(128)
------
============================================================================

What version of the product are you using? On what operating system?
 CentOS release 6.6 (Final)

Please provide any additional information below.
 I did REGEXP_MATCH with the below long text.
============================================================================
(【日韓】)|(【日曜経済講座】)|(【売れ筋)|(【悲報】)|(【報�
��発表】)|(【夕刊】)|(〔.*新聞〕)|(〔NHK〕)|(〔産経〕)|(〔衝�
��の写真〕)|(＜.*ニュース＞)|(＜.*新聞＞)|(＜.*速報＞)|(=今��
�はどんな日)|((s|　)２ｃｈまとめニュース速報)|(２ちゃんね
る 
ヘッドライン)|(47news)|(47NEWS（よんななニュース）)|(AKB48にゅ
ーす)|(Ameba News)|(Aviation Wire)|(BIGLOBEニュース)|(Bioimpact 
News)|(by楽天サイゾー)|(Careless Remark plus)|(CHUNICHI 
Web)|(DatNews)|(FNN_News)|(FNNニュース)|(Google 
検索)|(GoogleTrend)|(Google 
トレンド【)|(Googleトレンド急上昇ワード)|(Gunosy 
Newss+)|(Infoseek 
ニュース)|(INTERNET(s*|　)*Watch)|(INTERNET_Watch)|(IT(s*|　)*Leaders)|(IT
___news)|(itmedia:)|(ITmedia(s*|　)*ニュース)|(ITpro 
http)|(ITpro(s*|　)*総合)|(ITPro(s*|　)*総合)|(J-CASTニュース)|(jcast_
news)|(【JR.*運行情報】)|(ktai_watch)|(MSN 
トピックス)|(MSN産経ニュース)|(mynavinews)|(New post)|(New 
投稿:)|(news-us.jp)|(News i)|(ＮＥＷＳ　ＰＯＲＴ)|(News 
U.S.)|(news+)|(Newswire)|(NEWSアンサー)|(NHKs+)|(NHKニュース”)|(NHK速
報：)|(Photo:)|(RBB(s*|　)TODAY)|(Reading...)|(REUTERS)|(s-.*TBS)|(TBSの動�
��ニュースサイト)|(WEDGE関連)|(s-.*Y!)|(Yahoo!(s*|　)急上昇ワー��
�【)|(Yahoo!(s*|　)検索((|（))|(Yahoo!News:)|(Yahoo!ニュース検索)|(Ya
hoo!ブログ http)|(YOMIURI 
ONLINE)|(あとで見る。)|(インターネットコム最新ニュース)|(��
�び速 
:)|(オタク.coms)|(お知らせ】)|(キジトラ速報)|(ケータイ(s*|　)
Watch)|(ゲンダイネット 
http)|(タブクル)|(ニュース(s*|　)(:|：))|(ニュース(s*|　)-)|(ニ�
��ース d+年d+月d+日)|(ニュース 
ニュース)|(ニューストラベル(s*|　)(:|：))|(ニュース速報+＠2
ch)|(ニュース速報(+|＋))|(ニューリリースランキング)|(のク��
�コミ情報 
http)|(はちま起稿(:|：))|(ハムスター速報(s|　)*(:|：))|( 
ビデオニュース・ドットコム(s|　)インターネット放送局)|(�
��ぁにー速報(s*|　) 
(:|：))|(ブログを更新しました。)|(まとめアンテナ(s*|　)(:|��
�))|(ログ速(s*|　) 
(:|：))|(沖縄タイムス(s*|　)|)|(沖縄タイムス(s*|　) 
(:|：))|(過去d+年就職)|(懐古ワード)|(関連のニュース(s*|　)htt
p)|(急上昇ワード(s+|　))|(共同◆)|( 
空港情報(s+|　))|(携帯総合研究所(s+|　))|(県関連のニュース(
s+|　))|(最新動画ニュース⇒ 
http)|(産経ニュース-)|(時事ドットコム(s*|　)(:|：))|(時事通信
 ：)|(就職・転職ニュース備忘録)|(週プレNews 
http)|(旬ネタ/)|(新製品／携帯電話)|(新着ニュース(s|　)+)|(新�
��記事＞)|(新聞((|（).*()|）))|(新聞-更新(s|　)+)|(新聞NEXT)|(新�
��ONLINE)|(新聞デジタル)|((s|　)+-(s|　)*S*新報)|(政経ch)|(政治版
(：|:))|(速報経済)|(中国・韓国・在日朝鮮人崩壊ニュース)|(�
��京スポーツ新 
聞社)|(日テレNEWS24)|(日刊ゲンダイ|)|(日経◆)|(日本共産党の�
��んぶん赤旗)|(保守速報)|(毎日ｊｐ(毎日新聞))|(＜gooランキ�
��グ d+/d+ d時＞)|(goo エンタ)|(goo 経済)|(goo スポ)|(【CNET 
News】)|(【Reuters 
News】)|(〔外為マーケットアイ〕)|([Mainichi])|([Sanspo])|([Sportsnav
i])|(ロイター通信s*：)|([ZAKZAK])|(#ldnews)|(アメブロのニュース�
��)|(xあんどろいど速報)|([あんどろいど速報])|(【日経d+面)|(-
 Engadget Japanese)|(- ＠Press)|((プレスリリース))|(〔 
d+/d+)|(（SankeiBiz.*）)|(CNET 
Japan総合:)|(【中国】)|((［|[)日経(］|]))|((［|[)朝日(］|]))|(【�
��療】)|((［|[)はてブ(］|]))|((［|[)BLOGOS(］|]))|((［|[)産経(］|])
)|((［|[)共同通信PR(］|]))|((s|　)+-(s|　)MSN)|((s|　)+-(s|　)*ライ�
��ドアブログ)|((s|　)+-(s|　)*ツイナビ)|((s|　)+:(s|　)*痛いニ��
�ース)|(痛いニュース(ノ∀`)(s|　)+:(s|　)*)|(【レポート】)|(47
NEWS(s+|　+)＞)|((［|[)NBAニュース(］|]))|((s|　)*(｜||)(s|　)+月刊
馬泥棒)|(【やじうまWatch】)|((s|　)*(｜||)(s|　)+やっぱんつ.com
)|((s|　)+-(s|　)*BCN配信)|(《SOCCER 
KING》)|((［|[)人気記事(］|]))|((s|　)+真実を探すブログより)|(
(s|　)+真実を探すブログ さんよ り)|((s|　)+-(s|　)*nikkei 
Bpnet)|((s|　)+-(s|　)*オクトバ)|((［|[)NHK(］|]))|((s|　)+-(s|　)*ク
ラウド 
Watch)|(NTT西日本からのお知らせ【)|((［|[)アメーバニュース(�
��|]))|(ASCII.jp(:|：))
============================================================================

Original issue reported on code.google.com by ryoki.ta...@gmail.com on 22 Feb 2015 at 11:16

GoogleCodeExporter commented 9 years ago 
Thanks for reporting this, I'll take a look.

As a workaround you might do "bq --format=json show -j ..." which appears to 
dodge the character-set restriction.  

Then for this job you get to see "Failed to parse regular expression ... no 
argument for repetition operator: +".  I'm not sure if your regexp text came 
through cleanly (did we lose backslashes?) but this bit here 
"(ニュース速報(+|＋))" looks like it might be what the "repetition 
operator" message is complaining about.

And I'll update with status on the glitch.

Original comment by e...@google.com on 24 Feb 2015 at 8:43